title: How to link and ODBC table to MS Access database using VB and without connecting to the server?
body: <p>I have a VB procedure that changes a connection string for all 360 linked tables in my Access 2002 database. If I run this procedure using an SQL server in my local network, it runs about 30 seconds. The problem is that I have to use an SQL server somewhere in the Internet. In this case the procedure runs for about 5 minutes. 
  The question is - how can I prevent Access from connecting to the server to check every table I re-connect? </p>
  
  <p>An alternative question (maybe more correct).
  I need to run that re-connection procedure on every user's computer every time I give them a new version of the database, to save user's login and password into every linked table. Maybe there is some other way to set the username and password for the ODBC connection?</p>