INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Access 97 and Access 2003 on same machine?

Access 97 and Access 2003 on same machine?

(OP)
I need to have access 97 and access 2003 installed on the same machine. The reason being is that I have some databases that are access 97 versions and some that are 2003 and for various reasons, I can't yet convert the 97 ones to 2003.

My question is this, is there a switch or something I can put on the end of a shortcut's target to tell it which version of access to open that shortcut in? Hope that makes sense?

andy

RE: Access 97 and Access 2003 on same machine?

Use the full path of the desired msaccess.exe version in your shortcut.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

RE: Access 97 and Access 2003 on same machine?

PHV is correct (as usual)

Set 'Target' in Shortcut Properties to:

Something like:

"C:\Program Files\Microsoft Office\Office11\msaccess.exe" "C:\My Documents\YourDbName.mdb"

where the first path in quotes is the path to the msaccess.exe that you want to use to open the database (in your case either the Acc97 or Acc2003 exe.  

The second path is the path to your database or 'front end' if split database.  Hope this helps.  

RE: Access 97 and Access 2003 on same machine?

we have had 97, 2000 and 2002 0n the same machine with no problems.  READ the form about convertinf from 97.  In short you need to convert to 2000 first.

Never give up never give in.

There are no short cuts to anything worth doing   

RE: Access 97 and Access 2003 on same machine?

We can only get access 97 to run in runtime mode when any Office 2003 components are installed (on win xp). Any one else had this problem.

RE: Access 97 and Access 2003 on same machine?

I have 97, 2000, and 2003 all on the same machine without problems.  Main thing is to install in different directories, but try to find Microsoft article Q241141 for more details.

RE: Access 97 and Access 2003 on same machine?

My apologies I should have explained: Due technical reasons to convulated to bother explaining, we need to install Access 97 on pc's that already have Office 2003 components installed. It is this scenario that prevents Access 97 running in design mode. Any one else come across this problem?ponder

RE: Access 97 and Access 2003 on same machine?

install Access 97 on pc's that already have Office 2003 components installed
I think the proper order is:
1) uninstall all 2003 components
2) install 97
3) reinstall 2003 components

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

RE: Access 97 and Access 2003 on same machine?

Again, I will second PHV's thoughts.  We have consistenly seen problems when Access 97 (Runtime or Full Install) is installed after later versions.  The KB Article 241141 mentioned above even details certain problems that will occur. It is a pain to uninstall everything and reinstall - but I did it as recently as last week at a client site and it fixed the problems they were having.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close