Dynamic Table Linking

  • Thread starter Thread starter Shell
  • Start date Start date
S

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?
 
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)
 
Back
Top