Smart questions
Smart answers
Smart people
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 now!
  • 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.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

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.

spongmonkey (IS/IT--Management)
23 Feb 06 9:15
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
PHV (MIS)
23 Feb 06 9:31
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

evalesthy (Programmer)
23 Feb 06 12:07
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.  
assets (TechnicalUser)
27 Feb 06 20:34
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   

marshallk (TechnicalUser)
7 Mar 06 7:32
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.
JoeAtWork (Programmer)
7 Mar 06 23:00
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.
marshallk (TechnicalUser)
9 Mar 06 6:12
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
PHV (MIS)
9 Mar 06 6:20
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

evalesthy (Programmer)
9 Mar 06 10:42
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!

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