• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

shared access database prevent trying to change the same record

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

1 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.
Richard DanekeCommented:
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)
KnutsonBMAuthor Commented:
didn't see that i could do it on each individual form, works great, thanks!

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now