Ok, so If I'm following correctly, all I have to do is link the tables initially, and if the ODBC driver is installed on the computer, then it will work?
I already have the tables linked on the development copy of the DB, and when inside the firewall, I can access the tables....Now, if I were...
Scriver, with your method, would I have to do that on each PC that the application would be running?
CMM: For that to work, would I just have to change the first set up code
Set SQL Server connection string used in linked table.
sConnString = "ODBC;" & _
"Driver={SQL Server};"...
I have a little app here that is linked using and ODBC connection...The driver is installed on the computer in which it will be used, but how do I go about setting something up so that it will always connect to the specified ODBC connection, and not having to go into Control Panel --->...
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.