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.