Solved

ms access shortcut target

Posted on 2011-02-18
7
623 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

705 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