Access front end issue, form hangs randomly with sql back end - need troubleshooting help
Posted on 2009-02-24
History \ original configuration
Access DB 2000 format was running access 2002 front end and back end with no issues supporting about 12 users, 4-6 max running at a given time
Moved back end to MS SQL server, SBS 2003 premium so I think its SQL 2000 server, we are using ODBC connection on a machine DSN.
Most clients were accessing the DB in Access 2002 on a Citrix PS 4.0 running on Win std 2003 SP2 server, some clients use XP SP2 with access 2002
We have a 1 form that randomly locks in Access on the Citrix server. This could be via RDP or Citrix ICA session and takes 25% CPU when it hangs, this happens moving from record to record or when editing and saving, tested on a XP workstation and it has not locked when testing.
Check for latest MDAC and have re-install MDAC 2.8 SP2 - still hangs
Changed Access to 2007 on the Citrix server and company - still hangs
Turned on tracing for the ODBC session and didn't find anything there to help
Never hangs on an XP SP2 workstation when we have tested but most of the work is done on the Citrix server.
I have made a copy of the front end and changed the version from Access 2000 to 2007 - Im still testing that to see if it locks
What can I do to troubleshoot \ debug what is happening so I can resolve the problem?
Thank You in advance for your time