Access 97 and Office 2003 including Access 2003 on the same PC

[Dan Djuric]

My new PC has Office 2003, but some of the databases I use need to run under Access 97, so I loaded this on my machine as well.

I have created shortcuts to my old databases that explicitly call Access 97 with the .mdb file as a parameter. This works fine, but every time I use Access 97, it will change the .MDB file association to use Access 97 instead of Access 2003. I would prefer to have the .MDB file extention open Access 2003 by default.

To get around this, I was going to create shortcuts for my new databases using an explicit call to Access 2003 but I cannot find the executable. I have even looked at my existing shortcuts to Access 2003, but they don't point to any .exe file.

Any Comments?

 

[Douglas J. Steele]

Take a look for the file msaccess.srg in the same folder as the Access 97
version of msaccess.exe.

Rename that file, and Access 97 won't reregister itself each time it runs.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

My new PC has Office 2003, but some of the databases I use need to run

under Access 97, so I loaded this on my machine as well.

I have created shortcuts to my old databases that explicitly call Access

97 with the .mdb file as a parameter. This works fine, but every time I use
Access 97, it will change the .MDB file association to use Access 97 instead
of Access 2003. I would prefer to have the .MDB file extention open Access
2003 by default.

To get around this, I was going to create shortcuts for my new databases

using an explicit call to Access 2003 but I cannot find the executable. I
have even looked at my existing shortcuts to Access 2003, but they don't
point to any .exe file.

 

[Dan Djuric]

Thanks Doug

I renamed the msaccess.srg file and I recieved an error (registry related) when trying to start access 97, so I created a msaccess.srg file with nothing in it, and it works fine now