Error due to Access 97 and 2000 on the same machines.

[jinglin]

I have both versions installed on my machine.Since then I can never directly open any version's Access database. I have to go to Start,Program, then choose whatever version I need to open my access db. (I know this is the way to switch the Access Version)
Anything that I can do make my life easier? Please help...

Thanks!

Jinglin

 

[willir]

Jinglin

Create short cuts that point to the respective Access executable. BUT, you will only be able to open a database by file association (double click on database file within Explorer, or launch an Access application with a link) with one version of Access.

Richard

 

[jinglin]

Thanks, Richard! You're always helpful.
I created two different shortcuts which point to the different versions of Access exec. files. It's OK that I can open the respective dbs. If I'm already in 97 version and try to directly open up a 97 version database, I would get an error msg saying "The current user account doesn't have perssions to convert or enable this database." But I already joined the workgroup before I tried to open the database. Maybe it's registry problem.

Jinglin

 

[willir]

Your short cut probably needs to include the workgroup used with the database at the command line -- a little messier solution....

"C:\Program Files\Microsoft Office\Office97\MSACCESS.EXE" "F:\db\Your97DB.mdb" /wrkgrp "C:\Data\MDW\YourWorkGroup.mdw"

Obviously, you have to tweak network drive letetrs and directory locations and file names to accommodate your site.

Richard

 

[jinglin]

Thanks, it worked!

Jinglin