Converting Old Versions of MS Access to MS Access 97
Although we do not believe that you need to convert your old MS Access database to an MS Access 97 database, if you should want to, then the following are some possible solutions.
There are many variations on how to convert an old MS Access database to an MS Access 97 database. These depend on if you want to share the database with users who are using older versions of MS Access or if you want to convert a secured database, or a combination of these and others. So, the best way to find out how to convert a database according to your needs is to click on the Office Assistant icon in MS Access 97 and do a search on the string
convert which should list various help topics, the first of which should be
Convert a database. However, I will write a few simple database conversion scenarios below.
I want to convert my existing MS Access database to MS Access 97, but some or all other users will not be upgrading to MS Access 97...
Simply double click on the
*.mdb file you want to convert. This should launch MS Access 97. MS Access 97 will prompt you with a dialog box asking if you want to Convert the Database or Open the database. Choose convert the database. This will pop up a file dialog box which will allow you to save the MS Access 97 converted version of your old database to a new file. Pick a name to save this database as, and then click OK. Now, just wait for MS Access 97 to finish converting your database and you are all set.
I want to convert my existing MS Access database to MS Access 97, and all other users will be upgrading to MS Access 97 also...
As in the first scenario, double click on the
*.mdb file you want to convert. This should launch MS Access 97. MS Access 97 will prompt you with a dialog box asking if you want to Convert the Database or Open the database. Choose convert the database. This will pop up a file dialog box which will allow you to save the MS Access 97 converted version of your old database to a new file. Pick a name to save this database as, and then click OK. Once MS Access 97 has finished converting your database, close MS Access 97. Since all users will be upgrading to MS Access 97, you should probably also convert the workgroup file used to secure your MS Access database. This is not automated by MS Access 97, so it can be very tedious. Read the help provided by the Office Assistant in MS Access 97 by typing the search string
Convert a database. This will pop up a help window with help on various scenarios for converting MS Access databases to MS Access 97. Note: Your old workgroup security file will still work with MS Access 97.
I want to copy my converted database to a new machine. What do I need to do to make it work on the new machine?
You need to do the following things:
- Copy your converted database to the new machine.
- Copy the workgroup file used to secure the database on the old machine to the new machine.
- Set up the new machine to use the workgroup file you just copied over from the old machine when you are accessing the database.
- One way is to specifiy the workgroup file from the command line. To do this, you have to launch MS Access from the command line with the command line option
/wrkgrp C:\myworkgroupfile\wg.mda where
C:\myworkgroupfile\wg.mda is the path to your workgroup file.
- Another way is to join your copied workgroup file for the new machine. Do this by typing
Wrkgadm.exe from the Run... command of the start menu. This will pop up the Workgroup Administrator. Click the Join... button. This will pop up a Workgroup Information File window. In this window, click the Browse... button. Choose the workgroup file you copied to the new machine and click OK (For the demo database install, the workgroup file is in
cat_university_relations\databases\theRealThing\univ.mda). Now click OK in the Workgroup Information File window. And now click the Exit button in the Workgroup Administrator window. You should now be able to access your copied database on the new machine.