Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Opening a 2000 db in Access 97
- Thread starter netcert
- Start date
hope this helps:
Open the Microsoft Access database that you want to convert. 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.
Important If you have protected the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the Access database. To supply the password, start Microsoft Visual Basic by opening a module; then click databasename Properties on the Tools menu and enter the password in the databasename Password dialog box..
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.
On the Tools menu, point to Database Utilities, click Convert Database, and then click To Prior Access Database Version.
In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save.
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.
Open the Microsoft Access database that you want to convert. 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.
Important If you have protected the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the Access database. To supply the password, start Microsoft Visual Basic by opening a module; then click databasename Properties on the Tools menu and enter the password in the databasename Password dialog box..
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.
On the Tools menu, point to Database Utilities, click Convert Database, and then click To Prior Access Database Version.
In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save.
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.
- Thread starter
- #3
scotthellewell
Programmer
Install the runtime version of Access 2000 on the machines.
Scott Hellewell
Scott Hellewell
- Status
Similar threads
- Question
- Locked
- Question