Automating database table links for use by Queries

[Guest]

I have several Access 2002 databases that have the same
structure/tables/queries etc. Each is named differently
according to geographic area. I have a common database
for reporting purposes that contains links to each
respective geographic database. One copy of the reporting
database contains links to one geographic database. I
currently need one copy of the reporting database for
each geographic database because the links are different.
I would like to create the links dynamically using VBA
code so that the modied links can be used by Queries and
Reports in the reporting database. In other words, the
result of the VBA code should be seen in the Linked
Table Manager window by selecting the menu item:
Tools/Database Utilities/Linked Table Manager.

Is this possible?

 

[Marshall Barton]

I have several Access 2002 databases that have the same
structure/tables/queries etc. Each is named differently
according to geographic area. I have a common database
for reporting purposes that contains links to each
respective geographic database. One copy of the reporting
database contains links to one geographic database. I
currently need one copy of the reporting database for
each geographic database because the links are different.
I would like to create the links dynamically using VBA
code so that the modied links can be used by Queries and
Reports in the reporting database. In other words, the
result of the VBA code should be seen in the Linked
Table Manager window by selecting the menu item:
Tools/Database Utilities/Linked Table Manager.

Haven't I seen this question several times?

Yes it's possible and here's an article that should show
you most of what you need to do.

http://www.mvps.org/access/tables/tbl0009.htm