Thanks jfischer... that last reply of yours finally set me on the right path. :)
In the end I got so frustrated with it, I learnt enough VB to hack out a DSN-less solution, without the need to relink tables or anything else apart from running the code. Not pretty code (didnt bother with error...
Thanks jfischer
I did try this, and the DSN file had been changed... and if I edit that file using the ODBC administrator, the IP I want to change the connection to is there...
But whats driving me nuts is that its stgill connecting to the old IP. If only I could find out where it stores the...
Sorry if this has been repeated... Ive looked and didnt find anything, and Im tearing my hair out at what should be such a simple problem...
We are running Access with an SQL backend. The Access database apparently starts with a dsn file in the same directory. All I need to do is change the IP...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.