?
Solved

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

Posted on 2009-02-18
4
Medium Priority
?
249 Views
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.
0
Comment
Question by:airforcefrank
  • 3
4 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 23678027
try using the UNC path instead of a mapped drive path.  Here is a tip from www.aadconsulting.com  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.
0
 

Author Comment

by:airforcefrank
ID: 23678460
                    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?
Frank
0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 1500 total points
ID: 23681048
the back end.  This link should answer all your questions regarding setting Access up to run on a network.  Read it in its entirety.
                       http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Excerpt
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.  
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

839 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