Access 2000 to 97 conversion
- Thread starter mincher
- Start date
missinglinq
AWF VIP
- Local time
- Today, 12:19
- Joined
- Jun 20, 2003
- Messages
- 6,420
First off what database (don't see one attached). Secondly, there's a number of things that might have to be done, depending on the complexity/construction of the db. The below comments are taken from Access2000 Help:
"If it is a multiuser database that is located on a server or in a shared folder, make sure that no one else has it open."
"If you have protected the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the Access database."
"If you are converting a secured Access database, you must have Open/Run and Open Exclusive permissions for the database itself, and Read Design permissions for all objects in the database. To secure the converted database, you must open it in Microsoft Access 97 and apply user-level security."
"Note: If your Access 2000 database contains code, you may need to fix missing references after you have converted it to Microsoft Access 97. Also, if your Access database uses add-ins or library databases that were created in Access 2000, you must convert them back to Access 97 as well."
Because of the above, it might be best to have your source for the db do the backward conversion, as they would probably be better informed on many of the aforementioned issues. If you'll attach the db, I'd be happy to take a look at it this evening (US time) and give it a whack.
The Missinglinq
(35 years in a previous life as a "Phlegm Dredger)
"If it is a multiuser database that is located on a server or in a shared folder, make sure that no one else has it open."
"If you have protected the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the Access database."
"If you are converting a secured Access database, you must have Open/Run and Open Exclusive permissions for the database itself, and Read Design permissions for all objects in the database. To secure the converted database, you must open it in Microsoft Access 97 and apply user-level security."
"Note: If your Access 2000 database contains code, you may need to fix missing references after you have converted it to Microsoft Access 97. Also, if your Access database uses add-ins or library databases that were created in Access 2000, you must convert them back to Access 97 as well."
Because of the above, it might be best to have your source for the db do the backward conversion, as they would probably be better informed on many of the aforementioned issues. If you'll attach the db, I'd be happy to take a look at it this evening (US time) and give it a whack.
The Missinglinq
(35 years in a previous life as a "Phlegm Dredger)
Dear Missinglinq
...i think it should convert fairly correctly i am told by a voluntary group who produced it in seatle...
my email is paul.mincher@britishlungfoundation.com if i can send it directly as it is just over the file limit size for posting...
cheers
Paul
...i think it should convert fairly correctly i am told by a voluntary group who produced it in seatle...
my email is paul.mincher@britishlungfoundation.com if i can send it directly as it is just over the file limit size for posting...
cheers
Paul
missinglinq
AWF VIP
- Local time
- Today, 12:19
- Joined
- Jun 20, 2003
- Messages
- 6,420
Similar threads
