Access 97 conflict with Access 2000 runtime version

Access 97 conflict with Access 2000 runtime version

Post by TWlrZSBOZX » Tue, 13 Jul 2004 17:57:03


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
 
 
 

Access 97 conflict with Access 2000 runtime version

Post by GVaugh » Wed, 14 Jul 2004 06:00:20

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



vendor does not have or support a 97 version.
database very well.
overriden and I have to re-install the runtime version of access 2000 again
to run the 2000 database.
setting / changes I need to make to effect it.

 
 
 

Access 97 conflict with Access 2000 runtime version

Post by John Nuric » Wed, 14 Jul 2004 14:05:07

Hi Mike,

Possibly information and/or utility here may help:
http://www.yqcomputer.com/


On Mon, 12 Jul 2004 01:57:03 -0700, Mike Nesbitt <Mike



Please respond in the newgroup and not by email.
 
 
 

Access 97 conflict with Access 2000 runtime version

Post by david epso » Wed, 14 Jul 2004 14:07:22

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)





vendor does not have or support a 97 version.
database very well.
overriden and I have to re-install the runtime version of access 2000 again
to run the 2000 database.
setting / changes I need to make to effect it.
 
 
 

Access 97 conflict with Access 2000 runtime version

Post by TWlrZSBOZX » Thu, 15 Jul 2004 10:40:03

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
 
 
 

Access 97 conflict with Access 2000 runtime version

Post by Albert D. » Fri, 16 Jul 2004 06:18:26

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....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM
http://www.yqcomputer.com/ ~kallal.msn