Microsoft Access 2010 application relinks to sql dsn ODBC every time there is an update in the app
Posted on 2012-08-20
We have a microsoft access application, front end is on each local pc, we connect to the sql db with dns odbc. We were using access 2003 (both full and runtime for some pc's), all was working fine.
We upgraded the application, all works fine, until we start upgrading to office X on local pc.
The problem now is that every time there is an update for the application, we push the mdb to each local pc, when this happens, the first time user opens the application, it takes longer than usual like if it was relinking tables, finally it opens and works fine until there is another update of the application and same thing happens.
I do the updates on the mdb using access full version, so I don't have this problem, I assume that it's because I do the modifications on my own pc so I keep the 'same' file just make changes, I wonder if rewriting the file on the other pc is causing a kind of problem with the odbc trying to identify the file as the same one???
I have tried on pc running win 7 and xp and same problem, it doesn't make any difference if I use full access or the runtime version.
I have tried with users being administrator, providing full access to the folder containing the application and error persists.
When this happens, the size of the mdb file grows a few K's.
Has any body experienced a similar issue?
there is no problem at all if using access 2003, and the problem is not linked to the version of windows.
Thanks in advance.