467,911 Members | 1,356 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,911 developers. It's quick & easy.

How to change fixed path?

I have been given a database on a CD to do some work on. The only
problem is that when I open a form it tells me that the file path
//server/database/mydb.mdb is not valid. Of course it isn't valid the
whole thing is on my comp at the moment and not even on a network.

How can I change this path so that I can work on the database locally
and change it back when I put the changes back?

Thank you for any help.

Denis.
Nov 12 '05 #1
  • viewed: 28986
Share:
1 Reply
Denis,

Open the frontend to the database window and go to Tables. Go to Tools -
Add-Ins(Access97 and 2000) or Tools - Database Utilities(AccessXP) and find the
Linked Table Manager. Select all the tables and check "Always Prompt For New
Location". The wizard will hen allow you to pick the location of the backend
which contais the tables.
--
PC Datasheet
A Resource for Access, Excel and Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

∑ Design and basic development for new applications
∑ Additions, Modifications and "Fixes" for existing applications
∑ Mentoring for do-it-yourselfers who want guidance
∑ Complete application design and development
∑ Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel

<de************@yahoo.com> wrote in message news:3F***********@yahoo.com...
I have been given a database on a CD to do some work on. The only
problem is that when I open a form it tells me that the file path
//server/database/mydb.mdb is not valid. Of course it isn't valid the
whole thing is on my comp at the moment and not even on a network.

How can I change this path so that I can work on the database locally
and change it back when I put the changes back?

Thank you for any help.

Denis.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by rodchar | last post: by
19 posts views Thread by Ju Hui | last post: by
11 posts views Thread by cybervigilante | last post: by
1 post views Thread by Larry Bud | last post: by
2 posts views Thread by franc sutherland | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.