Changing ODBC connection of a file

[EdAROC]

We have an Access file where all tables are links to our (ERP) database, SQL 2000. We gave the file to another company using the same ERP app and SQL 2000. They are having a problem:
Our ODBC connection name is SQLBase_300 (a carryover from using SQLBase). Their ODBC connection name is not the same, let's say it's SQL1. (I'm referring to when you specify the System DSN in the ODBC Data Source Administrator control panel).

Is there an easy way for them to switch the ODBC to their defined one?

 

[dhookom]

They need to have a DSN created that points to their database. They can then use the Linked Table Manager to change all linked tables to their DSN.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]