I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access Board   Print This     

Access News / Other Topic

All other Access posts go here.
<><td bgcolor="#dadada" class="darkcolor2" align="center"
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Rainier
Schedule database
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2550
Hits

Thread 24 of 25
Thread Starter  

jman009
I need Security!!! *info required*
Hi, I'm doing a Uni report on the security features of Access., basically info on:, -related issues such as system and data access security, -user login facilities of access as well as machines etc, -performance considerations (info on access on a network), -Optimal number of users accessing files at one time if centralised etc, If you could help me out with this I'd be very grateful.
15 years ago
Nothing New Since Your Last Visit
3875
Hits

Thread 23 of 25
Thread Starter  

Rhowk
excel updates access db
Hi sorry if this question is insanely stupid, but I have a client who wants to use his excel spreadsheet to enter data for use on the web. I have linked the spreadsheet to an access DB and have linked the DB to a Flash front end( via ASP) so certain clients of his can get the data they need on the web. , , What I don't know how to do is write a macro or App that takes his data in excel and updates the DB on the webserver every morning at 9am. Should I have the DB in his office computer and have asp look on his office computer for the data, or should I just have the DB on the webserver (not in his office) and have excel update it remotely. Again forgive me if this is completely obvious, I'v e been teaching myself ASP and Access on the fly for this project and am a little over my head as usual, , Rh, [EMAIL]vaene@yahoo.com[/EMAIL]
16 years ago
Nothing New Since Your Last Visit
2003
Hits

Thread 22 of 25
Thread Starter  

Jocat
Synchronizing w/o network
I have a situation where we have a remote office and we want the staff to be able to enter complaints (and their subsequent resolution)into a database. Note that this office is not connected to our lan. We want to be able to view the information on that database at the home office. , , I am thinking of placing a replica of the remote office database on the home office lan and update it periodically. Because there is no network link to the remote office, what is the best way to update the home office lan database replica?, , We are using Access 97., , Any help or suggestions would be greatly appreciated., , Joe
17 years ago
1 Reply:

jdschram
best way? create an app using ASP...as far using just access...i would say create an FTP site where you post/DL/update the database
17 years ago
Nothing New Since Your Last Visit
2320
Hits

Thread 21 of 25
Thread Starter  

BD
any advice?!
i'm trying to get a form in access upon update - to have to have data entry into certain fields., , I'm aware I can specify this has to be entered in the table itslef - but I'm wanting this condition only on the form..., , Any advice/help on how I can do this?, , If so please reply here or e-m me on:, , be_insane@yahoo.com, , cheers
18 years ago
1 Reply:

dynamictiger
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2169
Hits

Thread 20 of 25
Thread Starter  

Neil Webre
Moving tables from back-end to local
I split an Access db using Tools ... Database Utilities ... Database Splitter. The process moved all my tables to a ..._be.mdb back-end database. But I wanted two of the tables to remain local. The process gave me no choice on which tables were to be moved - all went. , , Is there a quick and/or easy way to move the two back-end tables back to local, with all queries, forms, etc. adjusting to the move automatically? , , Neil Webre
18 years ago
1 Reply:

dynamictiger
Use the import tool to reimport the tables back again., , Then use the linking wizard to update the links., , HTH
17 years ago
Nothing New Since Your Last Visit
2133
Hits

Thread 19 of 25
Thread Starter  

Rick Carter
Future of Access?
I've heard that Microsoft eventually plans to move away from both the Jet engine and ADO. What are the plans for the future? It seems like the emphasis from both Microsoft and Borland is on building new ways to access SQL databases, but what about local tables? Will there always be some kind of support for local tables, and will Access always be part of the office suite?
17 years ago
1 Reply:

jdschram
from what I have heard, MS is abondoning Access, but will replace it with a desktop version of SQL Server, so you will still have the ability to create local tables.
17 years ago
Nothing New Since Your Last Visit
1639
Hits

Thread 18 of 25
Thread Starter  

ErnNJ33
Exporting a table to Excel
When I export a table to Excel I get an apostrophe in all of the cells. I assume this is a transition key but when I go into options/transitions the transition navigation keys box is not checked. How can I stop this? Thanks in advance for any assistance.
17 years ago
Nothing New Since Your Last Visit
2035
Hits

Thread 17 of 25
Thread Starter  

jdflux
Microsoft Jet 4.0 SP6 fix?
Hello everybody., I'm accessing an Access 2000 database via ODBC from a Java developed system., The problem I have is that after a few hundred operations on the database I get "Cannot open more tables" or "Object invalid or no longer set" error messages reported from my ODBC driver., I have checked the Knowledge Base from Microsoft and they say that SP6 for Jet 4.0 corrects this problem (see Q239114 and Q304536). But after installing it, I still get it., , Has this happened to anyone?, Does anyone know how I can solve the problem?, , Thanks in advance,, Jorge. Confused
17 years ago
Nothing New Since Your Last Visit
1739
Hits

Thread 16 of 25
Thread Starter  

jan71942
New member needs help
Hi, My organization is trying to locate a copy of the MS , Office 97 Developer Edition Update. We are currently users , of Office 97 and are not ready to undertake the upgrading , of all of our users to Office 2000 or Office XP. We are , trying to do some Indirect replication and synchronization , using Access but this requires the Replication Manager , which is included in the MS Office 97 Developers Edition., , We have searched all over the internet (surplus vendors, , liquidators, etc) trying to purchase this product and no , one seems to have it., , Please help, .
17 years ago
1 Reply:

mprestwood
Try eBay. I've had great luck finding pretty much anything. I checked and there's one there now going for about $50.
17 years ago
Nothing New Since Your Last Visit
1602
Hits

Thread 15 of 25
Thread Starter  

Christophe De Clercq
Help needed (JDBC)
Does anyone know how I can insert and retrieve serialized objects into/from a Microsoft Access Database using JDBC/ODBC?, , Thanks,, Christophe
17 years ago
Nothing New Since Your Last Visit
1759
Hits

Thread 14 of 25
Thread Starter  

Lucy
Access Samples Book
Are there any books that have examples of databases aside from northwind? I need one for tracking time work sheets. Please advise at your earliest convenience. Thank you. Big Grin!
18 years ago
1 Reply:

Occie
Hi,, , If you want to see some sample databases, go here [URL=http://officeupdate.microsoft.com/templategallery/default.asp]http://officeupdate.microsoft.com/templategallery/default.asp[/URL]
17 years ago
Nothing New Since Your Last Visit
1970
Hits

Thread 13 of 25
Thread Starter  

deleted_member
2 detail sections
I work for a government insurance program. I need to produce a report that repeats a series of information on one page. The first section has a leader paragraph and shows information for each insured member. The second detail section repeats the name of the insured and reports on a different set of information for each member. When I produce the report and duplicate the name with the other information, the report shows the information for both sections for each individual. This makes the report confusing and way too long. Is there a way to have two detail sections on one report?
17 years ago
1 Reply:

juanperro
I think in access you can't create multiple details sections like you do, for example, in crystal reports. What I think you can do is create another report with the information you want to show and then add it to the original one as a subreport. sounds good?
17 years ago
Nothing New Since Your Last Visit
1997
Hits

Thread 12 of 25
Thread Starter  

Skyusa11
Conversion from 97 to 2000
I am trying to convert an Access database from Access 97 to Access 2000 using the standard Access database conversion tool. I have followed the instructions I have gotten from Microsoft as well as from other websites including ensuring I am using not only a different new database name but putting it into a new folder., , The conversion utility compiles, converts and then signals 'Ready'. Upon looking for the newly converted database, however, it is nowhere to be found. A 'find' in Windows Explorer shows no new files created. So I have a utility running with no visible errors, but no resulting database., , Any ideas before the phones really start to ring?
18 years ago
1 Reply:

dynamictiger
Try creating a new database in 2000. Save the new database to a known file. Close it and find it, reopen it., , Import the old access 97 file using the import tool. This will force conversion., , Save it, findit, open it., , Now run VBA compile., , HTH
17 years ago
Nothing New Since Your Last Visit
2012
Hits

Thread 11 of 25
Thread Starter  

clowe
Access 2000 Developer's Edition
Hi, I am just starting out on a small project for a local non-profit organization. I know some Paradox and a little Oracle, but Access seems to me to make sense for our purposes, can't be too hard to learn, right? Anyway, I am familiar with Access 2000 but I cannot find where to buy the Developer's Edition. Also, the local software stores (CompUSA, OfficeMax, etc.) only have Access 2002 (XP) and have told me they are unable to order 2000. I am loath to try software that has just been released, but will I get support (other than sites like this one) for 2000? Last question, what kind of help am I likely to get on this forum?, Thanks
18 years ago
1 Reply:

dynamictiger
Try ebay for Access 2000 Developer, I don't think you will find it at retail level now., , Microsoft still supports Access 2000. However, you will find they are very expensive for any assistance. You will end up using forums like this one., , Forums are really here to help you when the answer is either not in the help system or the answer in the onboard help system is so vague you can't get it., , Good luck on the changeover., , HTH
17 years ago
Nothing New Since Your Last Visit
1819
Hits

Thread 10 of 25
Thread Starter  

Neil Webre
Upgrade Office XP Pro to XP Developers Ed.
I have an Access project that is going multi-user. I need Office XP Developer's Ed. to provide licensing for the distributed workstations. Anyone know if it is possible for Office XP Pro owners to upgrade to XP Developer's Ed. without having to buy an entire new copy of Office?, , N. Webre
18 years ago
1 Reply:

dynamictiger
You would simply buy the developer upgrade. I have just bought XP on ebay, so it is available if you look long enough., , HTH
17 years ago
Nothing New Since Your Last Visit
1917
Hits

Thread 9 of 25
Thread Starter  

MikeS
:confused How do I write parameter query form fie
I am using Access 2000 for a small manufactuing plant's customer, product, vendor, and order information databases. I am performing a parameter query to extract information from three related tables and combining the information on the form which has calculated fields. I would like to write this information to a table to save it for future costing reference. Is there a clean way to do this? Can it be done through code. I have very little VBA experience.
18 years ago
1 Reply:

dynamictiger
Mike, Access is a relational database. This means it should be normalised. Normalised is a specific term that refers to a number of rules on how the data is structured, and how it is stored., , Under the rules of normalisation you never store the results of a calculation. Rather you would calculate the result for analysis whenever you need it., , HTH
17 years ago
Nothing New Since Your Last Visit
2115
Hits

Thread 8 of 25
Thread Starter  

Jeff Estes
Pictures
I am creating a database for a service company that has 10 years worth of invoices to be put into the database. We decided to scan them all in, making the file name of the bmp as the invoice number. This invoice number is tied to the location that had the work done. What is the best way to put multiple pictures for a location. Or is there a better way to tackle this project? Any help is appreciated.
17 years ago
1 Reply:

Dan
If the invoice number is not necessarly unique number between the different locations I think the best approach would be to store the invoices in unique folders for each location.
17 years ago
Nothing New Since Your Last Visit
1704
Hits

Thread 7 of 25
Thread Starter  

GRAHAM
LINKING TABLES
I have created a link to a table in an external data base,the problem I have is I need to update this data base table without updating the table in the external data base? However, whenever the source table is updated I need to have this information.So in other words,I need the source table to update the link table but the link table cant update the source table? Can this be done? Any suggestions welcome. Thankyou.
18 years ago
1 Reply:

saleem
Make Copy of table in ur database. Write small utility on db opening that update records in the copy of table from external source. This will update ur table from linked database. whatever u want to add add directly to created copy of table
17 years ago
Nothing New Since Your Last Visit
2349
Hits

Thread 6 of 25
Thread Starter  

mmollett
Access
I have created a combo box from a table which, has a field called last name and a field called first names., In the combo box each filed is listed as a separate columm, but when I go to the form and click on the box only the last name appears, how do I get both fields to be reflected on the form. Do I need to run a query? Roll Eyes [EMAIL]michele.mollett@everestre.com[/EMAIL]
18 years ago
1 Reply:

Dan
Check the Column width property of the drop down list. You should see something like 1";1" and in the column count you should see a 2
18 years ago
Nothing New Since Your Last Visit
1773
Hits

Thread 5 of 25
Thread Starter  

Tulip123
Access97 security wizard
I have a problem with Access97 security wizard: when I start it I get a message saying that I am currently connected as the network manager and if I will continue than the data base and all its objects will become unsecured., , What does this message mean ? Is it a problem or should I continue ?, , Thanks !
18 years ago
Nothing New Since Your Last Visit
1573
Hits

Thread 4 of 25
Thread Starter  

Patricia R. Turner
access vrs paradox
Not sure where to put this, but I am interested in whether the general groups feels there is more of a market out there for paradox apps or access apps. Keeping this short i won't go into my background, but I am thinking of making a career change, currently i am not in a development enviroment but am thinking of getting back into it. I have developed apps in both Paradox (my first development platform, and my first love) and Access. I am thinking of getting back into the field developing stand alone apps and I guess I need to pick one or the other to use, and i am wondering which would be the better choice as far as more marketable? , , I hope this post makes sense as I need to make a decision on wheter to purchase the Paradox Development edition or the Office Developer tools., , I would appreciate the groups comments, either on here or via email. Thanks
18 years ago
17 replies. Last post:

brian p kim
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
4034
Hits

Thread 3 of 25
Thread Starter  

dhborchardt
query question
I have a column in a table that has age ranges, i.e. 18 to 30, 31 to 39, 40 to 49 etc. How do I separate the ranges and total them up? Can this be done in one query. For example, the result would come out: , 248 , 126 , 150 , , *248 18 to 30, 126 31 to 39
18 years ago
1 Reply:

wpantoja
Use the GROUP BY clause and the COUNT aggragate function to determine the total number of records within each age range., ,
SELECT,    AgeRange,    COUNT(AgeRange) AS Total,    FROM Table,    GROUP BY AgeRange,    ORDER BY AgeRange
18 years ago
Nothing New Since Your Last Visit
1636
Hits

Thread 2 of 25
Thread Starter  

BD
HELP Please .....
Please would somebody offer some kind of help and assitance..., , I am supposed to be developing some way of creating a CD refenece system., , Essentially it is a number of rack that will contain a number of rows and a number of columns.... due to wanting to expand the system these will need to be defined..., , a number of operations are therefore needed:, , looking to see how many rows are used in a column - therefore how many are free and which positions are free..., , the need is to then be able to "add" a new cd to a particalur slot., , the mention is by using 2lookup" tables... but to be honest I am stuck and in need of help and guideance.., , If anyone can provide an idea of how to deveop this I would be gratful.., , Regards, , BD Big Grin!
18 years ago
Nothing New Since Your Last Visit
1566
Hits

Thread 1 of 25
Thread Starter  

BrUuu
listview &popup menu
Hi,, Is there a way to use a popup menu inside a listview? Confused , Thanks
18 years ago
Nothing New Since Your Last Visit
1586
Hits

New Thread
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech