Solved

ms access shortcut target

Posted on 2011-02-18
7
605 Views
Last Modified: 2013-11-28
Hi I have created a shortcut to the database and in the target field of shortcut I have pasted the whole path.. The shortcut works fine  as long as the users have 2003 version of access. But recently some of them have installed 2007 access. And I do not want to change the MS ACCESS path for each and every computer they have got different version of access. Could you please help me in getting MS ACCESS path where the shortcut opens up the ACCESS. EXE irrespective of which version they have.
0
Comment
Question by:vihaan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 5

Expert Comment

by:nomorefuzzylogic
ID: 34926927
I have a recollection that this is down to Macro Security - at least that it caused problems on 2 machines with Access 2007 and an application that ran fine on 2003.
If you open via your shortcut on Access 2007 and then try to open a form you may get the security warning.
On these 2 machines I think I just allowed all macros to run - very limited security risk in my environment.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34927015
Well the path to the EXE will be whatever it is.

If you want the shortcut to open Access 2003, point it to the Access 2003 exe file.
Do this for the Access 2007 .exe as needed.

Remember that a user could have two versions of Access installed.
These exe files may be in separate folders.

Also consider that an Access 2007 formatted DB will open and work fine even in Access 2007 if you rename it to .mdb.
So having an Access 2007 format DB open in Access 2003 may yield the "Unrecognized DB format error.


If you ultimate goal here is to make one shortcut path to the "Main" Access exe, then:
Install only one version of Access (Access 2003 or Access 2007) on the computers.
Install this Access version to the exact same folder on all machines
DO NOT upgrade any databases to the 2007 format
Point the shortcut to locate this specific Access exe.


Perhaps I am misunderstanding something, so let;'s see what some other Experts post.

JeffCoachman
0
 

Accepted Solution

by:
vihaan earned 0 total points
ID: 34927181
If you ultimate goal here is to make one shortcut path to the "Main" Access exe, then:
Install only one version of Access (Access 2003 or Access 2007) on the computers.
Install this Access version to the exact same folder on all machines
DO NOT upgrade any databases to the 2007 format
Point the shortcut to locate this specific Access exe.


But some of the users has got 2003 and some of them have upgraded to 2007 . And the shortcut thats on the server is pointing to the 2003 Access Exe.  So what I Did was that for the users who has got 2007 , I just created a same Office 12 folder in the MS office folder and renamed it to Office11. So that worked.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34927343
That is what I meant.

The only issue with your method is that Office 11 is the official designation for Office 2003.

You may have issue with this arrangement when it comes to autoupdates,  Cals to MS for service...etc.
You may also have general issues with someone else assuming that the office version is 2003 when it is really 2007. (and Vice Versa.

"Perhaps"? , it would be safer to simply rename the folder: "Office"
0
 

Author Comment

by:vihaan
ID: 34927720
yaa. But evetually, everyone is going to have 2007 version. So I would have to change it to office 12 eventually. Up until then it works i guess.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34928123
ok
0
 

Author Closing Comment

by:vihaan
ID: 34990855
good
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question