trouble updating Access .ade or .mde with Windows 7 workstations sometimes
Posted on 2011-09-13
I'm an Access developer. In several different environments I'm actively working on Access programs running against SQL databases. I've been doing version control by simply copying the .adp or .ade or .mde file from the server to the user's workstation when the user logs on. I'm running into problems doing this with Windows 7 sometimes.
It seems Windows 7 gets one or more cached copies of the program saved somewhere, then keeps launching those. Even though there's a shortcut on the user's computer that points to the folder that has the newest version of the Access program file, the old cached copy keeps running.
I seems I'm more likely to encounter this problem if the Access program file is part of an runtime installation and is saved in C:\Program Files\AppName. But it still doesn't always seem to happen.
What are other people doing to solve this problem?