Solved

access help

Posted on 2013-06-20
1
166 Views
Last Modified: 2013-09-18
I am trying to use a server on a shared folder with my access data and I can’t get the access file to open on the work station. It keeps looking for the c drive but my work station is map drive letter Z how I change the path so it can open up on the work station. Keep in mind that I created a short cut to my server. I can run the program on the server ok. I am not an access person I am clueless.
Help!!
0
Comment
Question by:icuclay
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
Are you referring to linked tables, perhaps? So your Access database has tables linked to the C drive, but you now need to relink those tables to a file on the Z drive?

If so, you can use the Linked Table Manager for this. You didn't mention your version of Access, but in general this is same regardless:

http://office.microsoft.com/en-us/access-help/view-refresh-or-change-the-file-name-and-path-for-linked-tables-mdb-HP005187623.aspx

Be sure your Z drive is properly linked before you do this, and remember to check the "Always Prompt for New Location" box when doing this.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

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 The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
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…
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…

763 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

13 Experts available now in Live!

Get 1:1 Help Now