• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

access help

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.
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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:


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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now