By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

How to change fixed path?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.