Recent content by dodulo

The security settings are not for connecting to the DB Server, they are the MS Access local security settings. They are to prevent an unauthorised user who was able to ope the application from being able to access tables, modify data, delete data, etc. When access connects to the DB, the...

Amazing! F*** Microsoft! I have solved the riddle. Here are three procedures, and how the first two don't work! ' Demonstration of how to, (and how not to,) change the ODBC connection string for a linked table in MS Access. ' By Daniel Odulo, http://www.Odulo.com/Consulting/ ' 7 Feb. 2008...

Thank you Wayne for your suggestion, how ever, I have attempted this before with no success. Documentation does say that the Connect property is read-only on an existing tabledef, and, in my testing, the RefreshLink method had no effect. Daniel

I wish there was a way to delete junk replies. Which part of "unusable solution" did you not understand? Please read the original post. Thank you.

Hello, I've spent hours trying to find a solution without any luck! *** Situation *** I have a number of ODBC linked tables in an MS Access 2003 application. I want to be able to switch between source databases; i.e. between production and development databases, easily. *** What works ***...