.mdb lock unlock problem.
I have a multi user Delphi-Access application.
I am looking for a real simple code that i can make sure 2 people are not working on the same row at the same time.
I been reading about lock and unlock .
Is there a simple way just to make sure 2 people are not editing the same row at the same time.
I am looking for a real simple code that i can make sure 2 people are not working on the same row at the same time.
I been reading about lock and unlock .
Is there a simple way just to make sure 2 people are not editing the same row at the same time.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks Systan
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What versions of Delphi and Access are you using?
How are your multiple users editing records? (configuration and UI)
It is possible to use pessimistic locking, but you pay a performance penalty.
Your code is supposed to receive (trap) an error when you try to change a row that has been changed by someone else. Is this not happening?
How are your multiple users editing records? (configuration and UI)
It is possible to use pessimistic locking, but you pay a performance penalty.
Your code is supposed to receive (trap) an error when you try to change a row that has been changed by someone else. Is this not happening?
ASKER
Thanks for all your comments. I will try and sort through them.
I am using D2010 and access 2007.
I am using D2010 and access 2007.
congratulation, your on the Delphi Hall of fame, overall.