JetScootr
asked on
pts for twalgrave "Locked" error help
This is to give points to twalgrave for help with question
https://www.experts-exchange.com/questions/20403690/Trapping-Locked-error.html
Effort expended to help me was far above & beyond the call of duty...thanx much. Will post another comment once I get it fixed with details of how I fixed it. Seems the problem is twofold: I need to respect locks more, and code retries, etc. Switching to ADO and an ODBC connection is probably best, long term, but for now, DAO and smart coding will have to do.
Second: "Opportunistic Locking" (OpLocks) on the server side is also causing me problems. The IT folks won't turn it off. Oh boy. In the battle between App code and OS code, the App seldom wins - and I must try now to find a way to defeat this "feature" of Windows NT/2000 server.
(MS KB article 300216, 129202, etc)
Thanx again!
PS: you and inthedark gave the most, so I'm giving you both the whole points - 483. Others got some too.
https://www.experts-exchange.com/questions/20403690/Trapping-Locked-error.html
Effort expended to help me was far above & beyond the call of duty...thanx much. Will post another comment once I get it fixed with details of how I fixed it. Seems the problem is twofold: I need to respect locks more, and code retries, etc. Switching to ADO and an ODBC connection is probably best, long term, but for now, DAO and smart coding will have to do.
Second: "Opportunistic Locking" (OpLocks) on the server side is also causing me problems. The IT folks won't turn it off. Oh boy. In the battle between App code and OS code, the App seldom wins - and I must try now to find a way to defeat this "feature" of Windows NT/2000 server.
(MS KB article 300216, 129202, etc)
Thanx again!
PS: you and inthedark gave the most, so I'm giving you both the whole points - 483. Others got some too.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Will do. I'm excited to see what you come up with.
ASKER