Solved

ms access shortcut target

Posted on 2011-02-18
7
589 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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.
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…

919 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

22 Experts available now in Live!

Get 1:1 Help Now