I have an Access 2013 front end and sql server 2008 R2 backend. Users in our local office run a copy of the front end from their desktops without issue. Users in remote offices run the same file hosted on a Citrix server. Typically the first user to launch the file in Citrix has no problem, but subsequent users get a message that user admin has locked the file. Two things make this odd:
1. The front end was developed originally in Access 2003 and the 2003 version never caused this problem on Citrix.
2. A second database developed from the same bones is not having this problem. It was also an Access 2003 file upgraded to 2013.
I can launch multiple instances of the Access front end from Citrix and as long as I launch as second instance before my first instance fully loads, I do not get the locked file message, and neither do other subsequent users. This is currently how I am "clearing" the locked file.
I cannot tell if this problem is caused by a Citrix setting or an Access setting. I've done everything I can think of to make my two front ends identical, but still only have a problem with one of them.