• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • 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.
Help!!
0
icuclay
Asked:
icuclay
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:

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
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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