Changing the connection for linked tables

[peterDavey]

G'day,
I'm building an Access 2000 front end for a SQL Server database using linked
tables in Access. I have development, test and production SS databases and
I therefore need a way (using VBA) to change the name of the server that the
tables are linked to. I've had a look through the object structure but
couldn't see anything obvious.

Any help will be appreciated.

cheers
peterDavey
Melbourne

 

[Wayne Morgan]

The link is stored in the TableDef's Connect property. Here is an example
for relinking ODBC tables via code.

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

 

[peterDavey]

Thanks Wayne, much appreciated.

The link is stored in the TableDef's Connect property. Here is an example
for relinking ODBC tables via code.

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