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

Linked tables and replica on laptop computer

P: 5
I have a Database stored on the server, and a replica on a laptop, used for data collection in the field. The laptop is only connected to the network during synchronization. I am linking to tables in another database, maintained by another agency; the linked tables are used as the source for a lookup field. The data in the table I am linking to changes monthly.

If I have the table linked I get a network error when I attempt to access the lookup field when not connected to the network. If I use a make table query or import the table the table is not automatically replicated and I need to manually set the table to be replicable.

A copy of the database the linked tables are in is on the laptop hard drive. I need a way to set the linked table to look at a relative path, or have the make table query automatically replicate the table produced, or some other method I havenít though of yet.

Thank you in advance
Jun 19 '07 #1
Share this Question
Share on Google+
1 Reply

Scott Price
Expert 100+
P: 1,384
If you are still having problems with this, please see this thread: Linked table manager macro

It contains three different approaches to establishing/reestablishing the links to backend tables...

Aug 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.