Multiple versions of MS Access

[Rob@healthwa]

Hi

We are running XP-SP2 and Office 2003 as the basis of our SOE.

Can anyone tell me if there is a document available that explains the proper
process for installing multiple versions of MS Access (97, 2000 & 2003) on
the same PC?

Rob

 

[Douglas J. Steele]

Do a custom install, make sure you install them in separate folders, and
make sure you don't have the "Remove Previous Version(s)" checkbox checked.

Most people recommend installing them in chronological order, but I know
people who deliberately don't do that, with no problem.

To avoid problems with Access 97 reregistering things, go into the Office
folder (where msaccess.exe exists), rename MSACCESS.SRG and WIZARD.SRG
files, and create empty files with those names.

If you get an error about no license with Access 97, see
http://support.microsoft.com/?id=141373

Also, see what MichKa has at http://www.trigeminal.com/usenet/usenet019.asp
While it only mentions Access 97 and Access 2000, it applies to Access 2003
as well.

 

[Rick Brandt]

Hi

We are running XP-SP2 and Office 2003 as the basis of our SOE.

Can anyone tell me if there is a document available that explains the proper
process for installing multiple versions of MS Access (97, 2000 & 2003) on
the same PC?

Just install in different folders and make sure during install that you choose
not to remove any existing Office components. There are some advantages to
installing in version order, but that is not mandatory.

During use the most recently used version will register itself as the default
program for opening Access files, but that is a minor inconvenience. Just get
in the habit of opening Access first, then the file.

 

[Tony Toews [MVP]]

Most people recommend installing them in chronological order, but I know
people who deliberately don't do that, with no problem.

That would've been me. I've haven't installed Access in
chronological sequence for at least five or seven years on at least
six or seven systems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

Can anyone tell me if there is a document available that explains the proper
process for installing multiple versions of MS Access (97, 2000 & 2003) on
the same PC?

If you are developers there are some programs out there which will
automatically start the appropriate version of Access.

One of those is ACCVER - Allows you to work with multiple versions of
MS Access databases. Detects the version of Access used to create your
MDB, MDE or MDA files and either reports the version number or starts
the appropriate version of MS Access.
http://www.aylott.com.au/accver.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Rob@healthwa]

Thank you all for your assistance.

I have successfully installed and tested the 3 versions (in
Version/chronological order just to be safe).

Rob

 

[Douglas J. Steele]

If you are developers there are some programs out there which will
automatically start the appropriate version of Access.

One of those is ACCVER - Allows you to work with multiple versions of
MS Access databases. Detects the version of Access used to create your
MDB, MDE or MDA files and either reports the version number or starts
the appropriate version of MS Access.
http://www.aylott.com.au/accver.htm

Others include Total Access Startup http://www.fmsinc.com/products/startup
and AccessOpener
http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm

 

[Tony Toews [MVP]]

Others include Total Access Startup http://www.fmsinc.com/products/startup
and AccessOpener
http://www.openaccess.co.za/BlackAndWhiteInc/AccessOpener.htm

Thanks. Added to my standard blurb.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm