Theorical question (1 Viewer)

[kevlray]

We have an Access 2007-2010 database (converted from Access 2003) with an MS-SQL 2008 backend. Each user has their own copy of the front end.

We have the case where a sub-form accesses the same database as another form in the same Access application. Right now I see that there is no record locking (No locks) for the database, but the checkmark for Open databases by using record-level locking is checked. So if a user changes the information on the same database and same record at the same time as another user, does the last user that entered the data win?

 

[pbaldy]

If they had the record open at the same time, typically the first person to save wins; the second gets the error "another user has changed...". Shouldn't be hard to test though.

 

[kevlray]

It is on a production DB. They are supposed to get a sandbox someday. So until then no testing.

 

[pbaldy]

You can still test by having 2 users open the same record for editing at the same time, have each make a change and save, and see who gets an error. Presumably you can either edit an inconsequential field in a real record or enter a test record which you delete after testing. In other words, it's not going to hurt anything, you can always edit the record again back to what it was.