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?