Missing Links

[chipymunk via AccessMonster.com]

Good Saturday Morning to everyone..

I'm struggling with working on a database from home. At work, the database
is linked to a network drive and works fine. I grab a copy of the FE and BE
and bring it home wiht me. I load it up on my laptop, and the FE tries to
look for the tables on the network drive. Since I want to work on it locally
(for development and bug fixing), I click on Linked Table Manager and try to
link it to my local copy of my BE.

I have all my linked tables now pointing to my local copy, but when I open up
the main data entry form, it still wants to search for the network copy. How
can I hunt down a link somewhere? Is there a search or something I can do?

Chip

 

[Peter Hibbs]

Chip,

You would be better adding some code to your database project to
automatically re-link the FE to the BE each time you move the files.
Have a look at my BE Relink.mdb example.
Go to http://www.rogersaccesslibrary.com/OtherLibraries.asp, you will
find it there under Hibbs PeterS. You may also find the BE Update
Utility.mdb file useful if you need to make changes to the BE.

HTH

Peter Hibbs.

 

[Mark A. Sam]

Chip,

There may be some code using the path to the backend. Open a module and
bring up the search dialog (Ctl F) and search for the Drive letter where you
network datbase resides, like T: Also check that all of the tables do
indeed point to the local database.

God Bless,

Mark A. Sam