MS Access program on shared drive doesn't open correctly from a particular CPU

Posted on 2009-02-18
Last Modified: 2013-11-29
                 I use an Access program which is located on a shared drive (Z).  I recently acquired a new CPU, and mapped to the Z drive and connected to this program.  When I run the Access program on my computer I now get an initial error which says that the program cant find an image on the C drive. This image is the background image for the initial user Form and is stored on the Z drive. Access cant find any of the 12 different Form images and somehow is looking for them on the C drive.
      The program feeds a separate database also stored on the Z drive. I have tried a shortcut, copying and directly accessing the Access program but all result in the C drive error.  My mapping is correct and matches other users who have no errors. I can logon to other computers and the program works.  My content is enabled. Please help.
Question by:airforcefrank
    LVL 38

    Expert Comment

    try using the UNC path instead of a mapped drive path.  Here is a tip from  for an easy way to obtain the UNC path.

    In Access, select a table and right-click. From the popup menu, click Create Shortcut...
    In the Create Shortcut dialog, check the This Database is on the Network
    checkbox, and you can then copy the full UNC network path from the Full Network textbox.
    LVL 38

    Expert Comment


    Author Comment

                        I think you may be on to something. But let me clarify. I can go to the folder where the front end resides and use it correctly from one workstation. When I go to my workstation and go to the same folder and use the same front end it does not work correctly. My original concern was that a link between the front and back was broken but the problem is dependent on where Im sitting?
          Should I try to use a UNC to link my pc to the front end or to link my front end to the back end or something else?
    LVL 38

    Accepted Solution

    the back end.  This link should answer all your questions regarding setting Access up to run on a network.  Read it in its entirety.

    One last thing about linking the FE to the BE is that you need to always use what is called UNC path names (Universal Naming Convention). All this really means is that you REALLY REALLY REALLY do not want to use mapped drive letters when you link. Besides, mapped letters are a 20 year throwback to the old PC DOS and CPM days when we used floppy disks! (When is the last time you used a floppy disk). Don't use mapped drives to a file share on the server. Drive mappings have all kinds of problems. Just plugging in a USB jump drive (memory stick) into your computer and the drive mappings can change. Further, you have to setup EACH pc for drive mappings and that is a pain. Further, even plugging in a digital camera can change drive letters. So, just avoid drive letters and mapping like the plague. Simply put, don't use them, and they are horrible from a support point of view. If you do risk using drive letters, then you will get a large increase in support calls for your software.

    In other words, always use a path name to the back end files. What this means is when you use the linked table manger, always navigate through network places to the server, and then to the folder, and then the back end mdb file. DO NOT use mapped drives, and do NOT use the linked table manager to navigate to a back end by a drive letter.  

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    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…
    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    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 …
    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…

    746 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