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!
Convert Access 2000 to Access 97? 1
- Thread starter gritz
- Start date
Hi gritz
I reckon you have to open it in ACC2K then save it as a ACC95/97 file from there. If you don't have 'access' to ACCESS 2000 (groan!), then you're up the proverbial without the necessary propelling device!![[sad]](/data/assets/smilies/sad.gif "[sad] [sad]")
Chris
Varium et mutabile semper Excel
I reckon you have to open it in ACC2K then save it as a ACC95/97 file from there. If you don't have 'access' to ACCESS 2000 (groan!), then you're up the proverbial without the necessary propelling device!
Chris
Varium et mutabile semper Excel
-
1
- #4
hi probably silly question but have you been through the steps in Access 2000 help - convert a database! - this is the excerpt from the file.
Convert an Access 2000 database to Access 97
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.
cheers
Dianne
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.
Learn more about converting an Access 2000 database to Access 97.
Convert an Access 2000 database to Access 97
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.
cheers
Dianne
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.
Learn more about converting an Access 2000 database to Access 97.
- Status
Similar threads
- Locked
- Question