How to open Access database with correct version of Access?

[Ted]

Dear Sir or Madam,

There are 2 versions(97, 2002) of Access database in one PC. The problem is
that when I open the Access database(97 or 2002), it will be opened with the
default (or last used) version of Access which is not always what you want.
Would you like to tell me is there any way could solve it? At this moment, I
always use "mouse right click/Open with/Access 97 or Access 2002 each time.

Best Regards,

Teddy

 

[John W. Vinson]

Dear Sir or Madam,

There are 2 versions(97, 2002) of Access database in one PC. The problem is
that when I open the Access database(97 or 2002), it will be opened with the
default (or last used) version of Access which is not always what you want.
Would you like to tell me is there any way could solve it? At this moment, I
always use "mouse right click/Open with/Access 97 or Access 2002 each time.

Best Regards,

Teddy

Create a Shortcut on your desktop, or in an appropriate folder. The command
line would resemble

"C:\Program Files\Office\OFFICE11\MSACCESS.EXE" "H:/consulting/My.mdb"

Use the path to the appropriate msaccess.exe executable - probably OFFICE7 and
OFFICE11, but that depends on how you installed the two programs.

 

[Ted]

Dear John,

Thank you for your reply soon.

Regarding your advice, it works on my PC.
There is the other problem which is different path of Access in my
colleagues' PC. The environment is many people open different version Access
database in network harddisk from their PC.
For examplefor Access 2002)
"C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE"
"H:/consulting/My.mdb" or "C:\Program Files\Microsoft
Office\Office10\MSACCESS.EXE" "H:/consulting/My.mdb"
The only different is "Microsoft Office" and "Microsoft Office XP" in the
path of Access in my PC and my colleagues' PC.

Would you like to tell me that is there any method could solve this ? I hope
I and my colleagues could use the same shortcut of Access database.

Best Regards,

Teddy

 

[John W. Vinson]

Dear John,

Thank you for your reply soon.

Regarding your advice, it works on my PC.
There is the other problem which is different path of Access in my
colleagues' PC. The environment is many people open different version Access
database in network harddisk from their PC.
For examplefor Access 2002)
"C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE"
"H:/consulting/My.mdb" or "C:\Program Files\Microsoft
Office\Office10\MSACCESS.EXE" "H:/consulting/My.mdb"
The only different is "Microsoft Office" and "Microsoft Office XP" in the
path of Access in my PC and my colleagues' PC.

Would you like to tell me that is there any method could solve this ? I hope
I and my colleagues could use the same shortcut of Access database.

If the database is on a shared network folder you can use the actual network
path:

"\\servername\foldername\my.mdb"

I'm not sure about the path to msaccess.exe - since it could in principle be
installed anywhere, not even in the \Program Files\ folder or on the C: drive;
and since you will by definition have two msaccess.exe files, I don't know HOW
you could come up with a one-size-fits-all shortcut! I'll ask my colleagues
though, maybe there's some Windows trick I don't know.

 

[jacksonmacd]

Try this freeware:

http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm

 

[Ted]

Dear Jackmac,

Thank you for your information.

I find a solution to my colleagues who easy to use. That is batch file. I
put Access 97 and Access2002 msaccess.exe path to batch file. A shortcut is
created and call batch file with target Access database(97 or 2002) and
version number (97 or 2002). Thus batch file could choose correct
msaccess.exe path to open the target Access database by version number.
This solution has only one problem is that there is a cmd.exe window always
exist until I close the target Access database. I will figure it out in the
future.