I have a layout in my database thats basically a table of all of our records. Multiple users view this table then select a record to go into the actual record itself to work on it. The problem I'm having is when someone else is viewing this table and i enter the same table layout I get the (User is modifying this record)

 

is there a setting I'm missing or anyone have thoughts on why this is happening?

 

Thanks

Matt 

There is something missing from your description. You should only see this message when a user tries to open (modify) a record that's already open (being modified) by another user. Just viewing records should work fine for multiple simultaneous users. Perhaps you have some script triggers in place that try to modify the record being viewed? And what exactly is "a table of all of our records" anyway? Isn't every table "a table of all of our records (in that table)"?

 

Edited November 30, 201510 yr by comment