[Access] Access on Citrix problem
Access 2003 application, backend on separate server on the same network, people run application locally and with Citrix server. There is a complex form with about 10 subforms on it. When users try to add or edit record in subform sometimes occur a following error #3197:
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time". Also could occur other error "Not a valid bookmark"
Mostly error occur when Citrix server is heavy loaded. So I got a "feeling" that Citrix somehow reduce or cut Access cache or buffer it users to read records, and Access produce such error. After playing with different Jet setting I found that setting DBEngine MaxBufferSize option to 10000 eliminate mentioned error. Actually 10000 is empirical value, if we find some more precise value - I will publish it here.
And few more settings which could help Access to work smoother on Citrix:
- open frontend in exclusive mode
- turn off record-level locking
- move workgroup file to local disk
- use less subfoms, load subforms on demand
If you have any comments on this - please let me know