Changing target of a shortcut through a batch file

Posted on 2011-10-26
Last Modified: 2012-06-27
We have an Access database that uses the SageKey installation app for deployment.  However, the Access front-end that is loaded, resides on the server and is NOT installed during the user installation (hope that makes sense).  The installation routine, puts a very small Access database onto the users PC and puts the shortcut for that mde file on the users desktop.  I need to change the target for that shortcut to look at the file on the server (rather than the local file that was just installed).  

At the end of the installation, I can get the SageKey app to run a batch file, which ideally would change the target of the shortcut (I'm guessing through the registry).  Can this be done and can you give me any pointers?

Any help would be greatly appreciated - thank you.
Question by:Andy Brown
    LVL 19

    Accepted Solution

    The link below is a good resource to consider regarding your issue.

    LVL 84
    Also note that it is a very bad idea to share an Access FrontEnd file. Running that file over a network is certain to cause performance issues, recordlocking troubles, etc etc. You really should install the app on each user's desktop and allow those users to share the backend file.

    Author Comment

    by:Andy Brown
    Thanks guys.

    LSM - Don't worry it's simply a loader

    Author Closing Comment

    by:Andy Brown
    Great stuff - thank you.  That gave me everything I needed.

    Thanks again.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    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…

    779 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