?
Solved

.mdb  lock unlock problem.

Posted on 2011-02-12
7
Medium Priority
?
839 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:Grant1842
7 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 1200 total points
ID: 34880975

Thats really a function for the database to perform.
However if you want some kind of control, you can add a field to your tables that indicate that a record is currently in edit mode
You can make it a timestamp. If the record is opened, you insert the current time to that field. When the second user tries to open the same record, they receive a notification that the record is currently being edited and they can only view.

When the record is saved, set the timestamp field to null.
Using the timestamp, you can determine how long a record has been opened and if it is still valid, eg you don't expect someone to keep a record open for several hours
0
 
LVL 14

Expert Comment

by:systan
ID: 34881355
ewangoya?,
congratulation, your on the Delphi Hall of fame, overall.
0
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 34881383

Thanks Systan
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 24

Assisted Solution

by:jimyX
jimyX earned 400 total points
ID: 34881402
There are 3 types of records locking, you may read this article for more info:
http://www.databasedev.co.uk/multi-user-application-record-locking.html

The option you are after is:

In the MS Access go to:
Tools -> Options -> Advanced tab -> "Default record locking" check "Edited record".
0
 
LVL 19

Assisted Solution

by:Thommy
Thommy earned 400 total points
ID: 34885972
If you are using ADOConnection, this might be an option for you...

Achieve Record locking in Delphi 5-6 with Access 2000
http://www.delphi3000.com/articles/article_2538.asp?SK=
0
 
LVL 46

Expert Comment

by:aikimark
ID: 34893706
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?
0
 
LVL 12

Author Comment

by:Grant1842
ID: 34902347
Thanks for all your comments. I will try and sort through them.

I am using D2010 and access 2007.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Loops Section Overview
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question