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


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)

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


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

<div>
<div class="content wysiwyg-content">
I have a database split into a back end and multiple front ends with multiple users. &nbsp;There is a form that is to &quot;Check Out&quot; a part. &nbsp;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. &nbsp;We have already set the Default Record Locking to 'Edited Record', that prevents us from &quot;Checking In&quot; two different items to the same ID, but does not stop us from trying to check out the same part. &nbsp;Is there a way to essentially 'Save' the record and give the other individual a prompt that somebody is currently editing it?<br />
<br />
Thank you<br />
<br />
-Brandon
</div>
</div>


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

-Brandon

shared access database prevent trying to change the same record

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.