News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, December 16, 2004

[Access] Access on Citrix problem

Recently I got a chance to look at a known problem which occur when people run Access application on Citrix server. Here a problem description:
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


Post a Comment

<< Home