Solved

.mdb  lock unlock problem.

Posted on 2011-02-12
7
828 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya earned 300 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 24

Assisted Solution

by:jimyX
jimyX earned 100 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 100 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 45

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

691 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