Hard Code Linked Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to hard code what a path to a linked table would be without
going through the Linked Table Manager or a re-linking process?

My issue is that I'm installing a database with linked tables onto several
different networks. I can pre-determine what each path will be, but I can't
do the re-linking or the Linked Table Manager remotely for each network.

Any work-arounds?
 
The easiest way is to create a local table to contain table names and paths.
Before deploying the database, unlink all linked tables. Write code
(triggered by an AutoExec macro) to get the table names from the local table
(if no linked tables exist), and link them.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about Linked Tables 3
linked table 3
Break the linked tables 6
UNC path network performance 1
Linked Table Manager Errors 12
How to change linked table path 1
Change Path Of Multiple Linked Tables at Once 6
Linked SQL Tables don't report Cascading Updates and Deletes 2

Back
Top