How to change the DSN settings.

[Kish]

Hi

I try to change the DSN setting using DAO.
The database has a table named A table linked to SQL
server. While I open the database, I want to change the
DSN setting connecting A table.
How should I write VBA code ?

Please advise me.

Thanks,
Kish

 

[Douglas J. Steele]

My suggestion would be to avoid using a DSN at all.

See http://members.rogers.com/douglas.j.steele/DSNLessLinks.html for one
approach.