Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing an older Access database.
Message
 
To
26/04/2005 09:51:06
General information
Forum:
Visual Basic
Category:
Access
Miscellaneous
Thread ID:
01008440
Message ID:
01010651
Views:
21
You should convert it to a newer version to avoid issues with the newer JET engines. The only problem you might have is if the database is still being used by another older version.

If that is the case do the following:

Create a new empty database (2000, 2002, 2003, does not matter)
Link all the tables from the old database
Do all your processing thru the newer database. This should treat all the tables as if they were in the newer version.

Keep in mind that all the versions of Access have the same size limit, and if the error you are getting is related to DB size, you might need to repair/compress the DB. If the DB is larger than 500MB, break the table accros multiple MDBs and create one MDB that links them all.
Ricardo A. Parodi
eSolar, Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform