Switching a linked table from Dev to Prod

• Raphra

  Mr or Mrs. 500

  Points: 522

  More actions

  December 3, 2008 at 2:11 pm

  #94349

  Hi,

  I have an Access 2003 front end and a SQL Server 2005 backend. There are two servers: Dev and Prod.

  Now there are some linked tables in Access 2003 that are linked to the Dev Server. I want the tables now to point to Prod Server.

  Bottom Line: I want to change the ODBC connection of these tables. How do I achieve this?

• noeld

  SSC Guru

  Points: 96590

  More actions

  December 3, 2008 at 2:30 pm

  #907180

  Use "Linked Table Manager" in MS Access Front-End

  
  * Noel