Access Link Table Change?

[Lack]

We have just upgraded from SQLBase to using SQLServer while connecting to our Visual ERP software and using MS Access to run some other reports, etc.

The name of the "linked" tables in access have changed when now using the old linked Access database and trying to use it and connect to the new one. Is there a utility or soemthing out there to be able and run that changes tables in all the queries to the new names? I know they have the linked table manager but I do not believe this will do that (from the old names in SQLBase to the new table names in SQLServer. Any help would be greatly appreciated.

 

[Blorf]

Old name is like TheTable, and new is DBO.TheTable?

If So, rename the Link, removing the DBO. then your queries will work again.

If something else, well then, I don't know.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[Lack]

Thanks for the reply Blorf. Yes, that is exactly what I need to do. When I change the queries and make sure the new Tables are linked, I still get an error message that references the old SQLBase saying it can not connect. Am I still missing something? I am pretty sure that all the old references to the SQLBase in the changed queries are now directed towards the SQLServer DBO tables. Is there a universal change to change the Access DB and direct it now towards the SQLServer ODBC? Anyone?