All:

I am using Access 2010 and connecting to a project in Access 2000 format. The project uses an ODBC connection for its data source. I am trying to steer the application to a new ODBC DSN. I want to *replace* the old DSN with a new one I have created.

If I choose External Data --> ODBC Database I *can* link to the new DSN, but it wants to link all the tables as new ones, suffixing them with a number, so I end up with duplicate tables. Can't I instruct Access to replace the old DSN with my new one to avoid all this?

Thanks

Kurt

Hi Kurt,

Not sure if by using the Linked Table Manager you can "replace" the links but if not, I'd say delete all the linked tables first before using External Data...

Just my 2 cents...

Just delete all the tables (they're just links, not real data) and use External Data to link to the new odbc.

It's not worth the effort to play around with the Connect strings though I suppose you could - but dropping and relinking will be much simpler and faster.