Solved

access help

Posted on 2013-06-20
1
168 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
ID: 39265386
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

929 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

10 Experts available now in Live!

Get 1:1 Help Now