Solved

ms access shortcut target

Posted on 2011-02-18
7
587 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
  • 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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now