Running access 97 & access 2003 on the same machine

[billb]

Is it possible to run access 97 & access 2003 on the same machine?
The operating system is XP professional.

Thank you
Bill
please respond to this newsgroup.

 

[Rick Brandt]

Is it possible to run access 97 & access 2003 on the same machine?
The operating system is XP professional.

Yep. I have four versions on my work PC. Just install in separate folders and
tell each install NOT to remove existing versions.

 

[mkhmer]

Oh Oh....not conflict at RunTime for each version of db engine or object
model?

Can you run all db applicatin created with those four different Access
without any problem?

Sound cool there.

Cheer...

 

[Rick Brandt]

Oh Oh....not conflict at RunTime for each version of db engine or object
model?

Can you run all db applicatin created with those four different Access without
any problem?

Sound cool there.

Yes there are "issues". Whatever version was last opened takes over file
associations for Access. This basically means that when you have multiple
versions of Access on one PC that you have to forget about opening files by
double-clicking them. You open the desired version of Access first and then the
desired file from within using the File menu. For common files you can create
shortcuts that explicitly point to the correct Access version and then the file.

I do not advocate installing multiple versions of Access on *Users* machines. A
good developer should supply a version that is compatible with the Access
version that the user already has. For *Developers* though it is almost
essential to have multiple versions installed and the issues described above are
of little consequence if you are aware of them.

 

[Douglas J Steele]

Yes there are "issues". Whatever version was last opened takes over file
associations for Access. This basically means that when you have multiple
versions of Access on one PC that you have to forget about opening files by
double-clicking them. You open the desired version of Access first and then the
desired file from within using the File menu. For common files you can create
shortcuts that explicitly point to the correct Access version and then the

file.

There are 3rd party products that may help.

ACCVER from: http://www.aylott.com.au/software.htm
Total Access Startup from http://www.fmsinc.com/products/startup
Access Opener from
http://www.worship.co.za/BlackandWhiteInc/AccessOpener.htm

 

[Rick Brandt]

There are 3rd party products that may help.

Agreed, but I would not recommend that as a *user* solution on a *user's* PC
and frankly I don't know why a seasoned developer would need such a utility.
Opening files by file association is just not that big of a deal for Access
files for most people. Most (corporate) people who have Access installed
have never even opened it. It is simply there because they have Office Pro.

Opening by double-clicking is handy for a person who uses Access a LOT and
has many different files that they are opening frequently. IMO installing a
different version of Access on that user's PC along-side his primary version
would be an irresponsible thing to do.

 

[Douglas J Steele]

Agreed, but I would not recommend that as a *user* solution on a *user's* PC
and frankly I don't know why a seasoned developer would need such a

utility.

Some developers aren't sufficient well organized to know in advance what
version of Access they need to open the database. <g>

I agree that users shouldn't need multiple versions.