We have many in-house databases that have have an SQL 2008 back end, and a .ADE MS Access front end. Users have been using these for years on their desktop PCs, where the ADE file is copied to their hard drives.
We have users now moving over to a Citrix XenApp 6 thin client environment, where their user folders are redirected to their personal network share. Although these ADE files were originally created on Access 2003, it is Access Runtime 2010 that I have installed on the XenApp servers, so the ADE files have been modified to work on Access Runtime 2010.
Rather than keeping with the current method, we don't want these ADE files to be copied to the users personal network shares - because this would mean dozens of copies of the same file filling up our file servers. So I set up a system where the ADE files are all kept in one central network share, and then group policy drops a shortcut to these files on the users' desktops. This works well, and is quick, if there is only one user using the ADE file. But from my tests it doesn't look like multiple users can connect to them simultaneuosly. As far as I can see, the reason for this limitation comes from the fact that the ADE file is opened by Access in "writable" mode. Access does this just to update the timestamp on the file.
Is there a way that the ADE file can be modified to allow multiple users to connect at the same time? I guess one way would be to try to stop Access from wanting to update the timestamp of the file, but I don't know if this is possible.
Any suggestions would be welcome.