May 25 2012, 12:48 PM
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?
May 25 2012, 12:53 PM
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...
May 25 2012, 04:11 PM
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.