ODBC DSN error in MSaccess database only when disconnected from wireless and only on one laptop
Posted on 2014-09-23
We have a small MS Access database that is being used (for a while now) on 6 laptops (win 7). The database runs in earlier version (mdb) mode but all laptops are using Access 2007. The users work in it locally until they want to sync with the office. We have an upload/download procedure that uses the odbc linked tables to their sql server data. Recently a new laptop was purchased and set up the same exact way as the others. On this new laptop, everything works fine in the database until the wireless internet connection is disconnected, then while accessing local forms and data, we get a few DSN, odbc errors and the user cannot use it. In the office, this happens even though they are still connected to the network that the dsn uses. It is only when they disconnect the automatic wireless connection for the internet. No linked tables are being accessed when this happens. I'm stumped! Does anyone have any ideas? The sql server driver is also the same version number as the other laptops. The company's network IT says it's our problem (software) but I can't find any reason or any difference between the working laptops and this one.