Dynamic Table Linking

[Shell]

In Access 2000, I have an MDB with several linked tables. Actually, the
linked tables are in 4 separate MDBs in different directories.
During development, I can easily, manually, link the tables from the proper
MDBs.

BUT, when I install the MDBs (code MDB and data MDBs) the users need to
places these MDBs in different places. Actually, I know the directory
structure for each user. It is something like
D:\FeedServer\AccessReportingTool\USERNAME\

How do I relink the tables?

 

[Jack Leach]

Have a look here:

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

If you just want to relink other access tables, the structure is similar to
this:

Dim td As TableDef
Set td = TabelDefs("tablename")
'look at the connect property and change it's path
td.Connect = NewConnectwithNewPath
td.Refresh
Set td = Nothing


hth


--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)