shared access database prevent trying to change the same record

Posted on 2011-10-28
Last Modified: 2012-05-12
I have a database split into a back end and multiple front ends with multiple users.  There is a form that is to "Check Out" a part.  if two people are attempting to check out the same part, it does not give any indicator that somebody is working on it until you try and 'save' your changes.  We have already set the Default Record Locking to 'Edited Record', that prevents us from "Checking In" two different items to the same ID, but does not stop us from trying to check out the same part.  Is there a way to essentially 'Save' the record and give the other individual a prompt that somebody is currently editing it?

Thank you

Question by:KnutsonBM
    LVL 77

    Accepted Solution

    Default Locking setting only applies to forms created After you have set the default.

    Any forms created earlier will be set to the previous default value.

    Look at the Lock setting for each form (in form properties) to check that it is also set to edited record.
    LVL 18

    Expert Comment

    by:Richard Daneke
    Have you noticed if you get the 0 with a / in the record selector bar (the left edge of the form?)  This would indicate that the record is being edited by another user.  (We used to call this the 'Ghost Busters' symbol, it is just the international NOT PERMITTED or NOT ALLOWED)
    LVL 6

    Author Closing Comment

    didn't see that i could do it on each individual form, works great, thanks!

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now