Switching a linked table from Dev to Prod

  • 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?

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


    * Noel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply