Access 97 and Access 2000 2

[HeyNewgirl]

Hi,

I have both Access 97 and 2000 loaded on my machine. I have a database that has to run on 97 but 2000 keeps starting up. How can I get this database to run off of 97 and not 2000 when I start the database?

 

[Lightning]

In the situation where you have more than one version of Access on the same PC, the version last used will automatically start if you try to open a db by double-clicking on it, or by clicking on a desktop shortcut icon.

The easiest way around this is to add the path to the MSAccess.exe file to the short-cut. This tells the shortcut which version you want to use for this db.

In your case, you would add the path to the Access 97 executable. Assuming the path is Program Files\Microsoft Office, you would set the shortcut's Target as:

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "Your Db path\Your DB name"

Note: you must use the quotes if there are spaces in your path names.

HTH
Lightning

 

[thornmastr]

Access has this peculiar fluke by design which calls the last Access version called. Therefore, if you last used A97, and you have an A2K mdb called thisone.mdb and you double click thisone.mdb, Access97 starts and you get nowhere fast. What, do you really expect MS to make your life that easy?

you have two choices. you can define two shortcuts on your desktop; one for A97 the other for A2K. Click the shortcut you want to use and open the appropriate db after you open the appropriate version of Access.

The other methodology, especially when you are dealing with only two choices, i.e. A97 and A2K. Rename all your a97 mdb’s from mdbname.mdb to mdbname.A97 and then associate the A97 extension with A97.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com