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...


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...


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: