Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Tables relinking and ODBC
> That way you don't have to worry about DSN changes. They are right there in your code. Well, that's what I'm trying to avoid - edit app code every time server ip/username/password is changed. Updating ODBC registry info is more flexible solution.- plauriz
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Tables relinking and ODBC
Hi everyone, I'm having a hard time relinking tables in Access. I have a code which: 1. checks the registry for ODBC username/password/server to be used 2. if currently linked tables have different info then the one in registry - table relinking is triggered. Now, if I relink one of table...- plauriz
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
