?
Solved

ms access shortcut target

Posted on 2011-02-18
7
Medium Priority
?
642 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
Industry Leaders: 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

765 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