Access 97 conflict with Access 2000 runtime version

M

Mike Nesbitt

Our corporate office software is still office 97!

I want to purchase a program which uses an access 2000 database, the vendor does not have or support a 97 version.

I have therefore installed Access 2000 runtime version which runs the 2000 database very well.

However as soon as I open access 97, all the run time 2000 settings are overriden and I have to re-install the runtime version of access 2000 again to run the 2000 database.

It seems that I can have one or the other, but not both!

Does anyone know if it is possible to run to two together and if so what setting / changes I need to make to effect it.

Thank you
 
G

GVaught

To my knowledge there is no work around. This is why it is important that
when one office/person upgrades everyone upgrades.

You could try creating a shortcut to your Access 97 database that points to
the 97 version of MSAccess.exe. However the problem lies when one database
version is open any database opened by double-clicking will pick up the
version opened even if that database was developed in another version.

The only time I could have two versions open side by side was to physically
open the other version through the Start | Programs menu.

--
G Vaught

Mike Nesbitt said:
Our corporate office software is still office 97!

I want to purchase a program which uses an access 2000 database, the
vendor does not have or support a 97 version.
I have therefore installed Access 2000 runtime version which runs the 2000 database very well.

However as soon as I open access 97, all the run time 2000 settings are
overriden and I have to re-install the runtime version of access 2000 again
to run the 2000 database.
It seems that I can have one or the other, but not both!

Does anyone know if it is possible to run to two together and if so what
setting / changes I need to make to effect it.
 
D

david epsom dot com dot au

If you delete the contents of the file MSACCESS.SRG, then you will not
need to re-register ('re-install') Access 2000 after running A97.

However, this will leave A2K Runtime as the default version of Access,
so you will have problems if you double click on an MDB file. You will
have to open A97 first, or use a special 'Open With' action to start A97,
or build shortcuts to your A97 databases. I don't mind that, and it works
ok for me.

Unfortunately, there doesn't seem to be any equivalent simple way to
prevent A2K (runtime or retail) from registering as the default: (i think
there is an equivalent file, but it is bound up in the installation
package??)

(david)



Mike Nesbitt said:
Our corporate office software is still office 97!

I want to purchase a program which uses an access 2000 database, the
vendor does not have or support a 97 version.
I have therefore installed Access 2000 runtime version which runs the 2000 database very well.

However as soon as I open access 97, all the run time 2000 settings are
overriden and I have to re-install the runtime version of access 2000 again
to run the 2000 database.
It seems that I can have one or the other, but not both!

Does anyone know if it is possible to run to two together and if so what
setting / changes I need to make to effect it.
 
M

Mike Nesbitt

Thanks David

I have not needed to go the route of deleting the MSACCESS.SRG file as I am happy to leave A97 as the default. However the "open with" option has provided a very workable solution which I am going to use.

Thanks for taking the time to post a possible solution that I can use

Regards

Mike
 
A

Albert D. Kallal

that runtime 6 should prove a proper shortcut, and thus it should work fine.

also, if you provide a proper shortcut for your access 97 appellation, then
once again it should run just fine.

I would try making a short cut for your application, and also find out why a
proper shortcut of the runtime app is not being provided....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top