Changing the connection for linked tables

  • Thread starter Thread starter peterDavey
  • Start date Start date
P

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