JetScootr
asked on
pts for elijahbailey - "Locked" error help
This is to give points to elijahbailey for help with question
https://www.experts-exchange.com/questions/20403690/Trapping-Locked-error.html
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!
https://www.experts-exchange.com/questions/20403690/Trapping-Locked-error.html
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.