How to avoid this?

[sondriven]

I have Access2000 and 97 on my computer and have 3 shortcuts on the desktop to the various databases. Two built upon 2000 and one upon 97.

I start up the computer and open lets say one that was built on 2000. It opens up fine. Then go to try and open up one that was built with 97. I get an error, "cant read format"

Shut computer down and open up the 97 first, it reads then try a 2000 file and get the same error.

Is there a way to tell the shortcut to start in the corresponding Office version before it trys to open the file?

This stinks. I came into this company and the guy before me had all these databases built in different versions.

Thanks.

john

 

[Nero]

Right click on your shortcuts and make sure that each one is pointing to the right version of Access.
ie"C:\Program Files\Microsoft Office2k\Office\MSACCESS.EXE" "C:\YourFolder\YourDb.mdb"