Splitting Access file in two from Accde and accdb the shortcut fails on client machines

Posted on 2011-04-25
Last Modified: 2012-05-11
We recently split a Microsoft Access 2007 accdb file into two separate files so that users would not accidentally get into the debug mode and unintentionally change code. (which was happening occasionally)
After we did the split we created a shortcut from our Windows 2008 Server to the clients to the ACCDE file which on the server gives us a good shortcut from which to launch the application.
However when we go to the clients and try to launch from the same shortcut we get the " Path was not found to the ACCDB file. So testing the shortcut on the server to the ACCDE works just fine.

We thought since the ACCDE is on the Server but launching it fails with the error "path not found to the ACCDB file " which on the client machine was located at C:\.........\Data|\Ourdatabase.ACCDB It would seem that the client machines are looking locally on the C:\ drive when they should be looking on the Server.

Does anyone know how to solve this or are we looking in the wrong place......Please advise. Thank you.
Question by:ruavol2
    LVL 14

    Accepted Solution


    If the file is on the server the correct path would be \\servername\serverdrive\xxxx.accdb

    If the server drives are mapped locally then the path would be x:\xxxx.accdb where x = the mapped drive.

    You will need to change the user shortcuts.


    LVL 14

    Assisted Solution

    by:Bill Ross
    Another option would be to copy the accde to the local computers and run each as a separate "front end" against the shared data "back end".  This is the more classical way to get the best performance from an access application.

    LVL 77

    Assisted Solution

    It doesn't matter where you put the files- Access always runs on the user's machine so C:\ will always refer to that user's C drive.

    You need to build  a 're-linking' feature into your application so that you can set the backend path correctly when you install the application or just use the Link Tables Manager to perform the re-linking on one copy of the front-end and distribute that copy to all users'.

    Sample re-linking code here:
    Note that you must also include other code procedures as described in the text at the top of that page.
    LVL 20

    Assisted Solution

    Make sure you're not linking the Front-end to the Back-end using a MAPPED DRIVE LETTER.
    For instance;   "G:\YourDataFolder\YourData.accdb"   should look something likel  "\\YourServerName\YourDataFolder\YourData.accdb"

    Scott C
    LVL 100

    Assisted Solution

    Posted for ruavol2

    Issue is resolved by recreating the accde and accdb files.
    When we originally split the database we were logged into the server and just put the resulting accdb file in the same directory.  We then created the accde fiel and it worked fine for us.

    When the new shortcut was copied to the users, the accde file executed but was looking for the db files on the C drive.  I assume it was looking on the users C drive.

    I resolved this by going back to the original accdb file and this time when we split the database I went through the network path to the server.  Saved the file in the same location but the accde file now looks on the server path.

    peter - Since the accde file doesnt really contain the datafiles will the relinking work if we need to move the database for some reason?

    Bill - your idea would work if the shortcut was the issue.


    Author Closing Comment

    Thank you for the clarity.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    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…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now