Connect Access to SQL Backend on New Server
Posted on 2015-01-01
I am not a SQL DBA or and Access developer.
We are in the process of moving to a new SQL server. The server is up and running and the databases are moved and up.
However we need to redirect the access database to the new SQL server.There is only 1 table affected.
When I look at the properties of the table I can easily see the ODBC connection defined to the old server.
I've tried to use the Linked Table Manager but I received an invalid procedure call or argument error. I've tried to re-register the accwiz.dll and the did not work.
I have also created a seperate System DSN for the new server and can connect. I do not know how to get the database connected though.
I have also take the step of trying to delete the table link from the front end Access and re-add it. But instead of 1 link to database, it links to ALL the tables.
I am obviously missing something here.
Any assistance with this would be very appreciated.