Link tables in another database in VBA

[Rich Stone]

I have a database that is installed on several different machines. However,
the drive they are installed on is different on each one. The database keeps
the data seperate so that when backed up, it's not copying the whole database
each time but just the tables, which happens quite alot as these are shared
amongst the group of users via email.

At the moment, I have to establish the link between the main database and
the database holding the tables manually on installation, but I would like
the main database to be able to do this automatically using a specified path.
Please note that the tables are always linked and not imported. Further, I
would also like to check if the tables are linked already each time the
database is run.

Is this possible?

 

[Allen Browne]

See:
Relink Access tables from code
at:
http://www.mvps.org/access/tables/tbl0009.htm

 

[Rich Stone]

Thanks Allan. However, that does seem to be rather complicated. It's just one
other database with three tables that I wish to link each time the program is
run. The database with the tables is in a subfolder of the the folder where
the main database is. I would have thought this would be a simple function.
Perhaps it's that my programming is not quite up to standard!

 

[Allen Browne]

If the front end and back end are both in the same table, you can use this:
http://allenbrowne.com/ser-13.html

 

[Allen Browne]

Correction: "... in the same folder..."