Creating database links

[Ed]

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

 

[John Nurick]

Hi Ed,

One way is to write code that uses
DoCmd.TransferDatabase acLink...
to create the linked tables you need.

 

[Klatuu]

If it is other Access mdb files you want to link to, you want Tools->Database
Utilities->Linked Table Manager