Creating database links

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

Guest

I would like to create a new database that has data linked to many other
databases. I am able to create a link to an individual file and that works
fine. However when I create the link, the screen that allows you to select
the file only allows you to select one file. Is there any way to select more
than one file? I have a strange case where I need to link a large number of
files. I would hate to have to link each individual file.
Thanks
Ed
 
Hi Ed,

One way is to write code that uses
DoCmd.TransferDatabase acLink...
to create the linked tables you need.
 
If it is other Access mdb files you want to link to, you want Tools->Database
Utilities->Linked Table Manager
 
Back
Top