Block Access to a Record

[Subwind]

Is it possible to block access to a record if someone already has it open? I am thinking I would have to add a new field in the table, something like, strRecordOpen (True or False), and when a person opens that record, change it to True, and when the close that record, change it to False.



Has anyone ever done this kind of method before? The only issue I can see is if someone closes the form without using the proper button and it does not update the strRecordOpen field.

I would want the user to receive a pop up message telling them that the record is being used, and the person that is using it.

~Matt

[burrina]

What exactly are your requirements for doing so?
Under Tool-Options-Advanced select under Record Locking - Edited Record.

[Subwind]

What exactly are your requirements for doing so?
Under Tool-Options-Advanced select under Record Locking - Edited Record.

I already have this in place, however this only blocks the main form from being changed and not the subform. Basically, I want to be able to tell when people are accessing records.

[burrina]

You want a record when the record was accessed? If yes, then that's easy! You need a user table,a table for In/Out and a table to catch the date and time.