Record locked by another user.

[mattfox]

I have database installed and running on one computer with eight other computers accessing it and running it.&nbsp;&nbsp;I have the database setup to allow shared access, but I do not have users setup on it.&nbsp;&nbsp;I get the message stated above in my subject every once in a while on their network.&nbsp;&nbsp;I have now installed the same database at another one of our offices and three computers use it.&nbsp;&nbsp;Everything is setup the same way and they get this error message all of the time.&nbsp;&nbsp;I would think that a network with a smaller amount of computers would run into this problem less than a network with a larger amount of computers!&nbsp;&nbsp;I am stumped!<br><br><br>Matt

 

[famousb]

You can set Access' record locking to No Locks, All Records, or Edited Record depending on how you want to set up your database.&nbsp;&nbsp;In most instances (my opinion here) the Edited Record is the most useful.&nbsp;&nbsp;If one user has a record open, and another user wants to change something, the first user has to go to a seperate record.&nbsp;&nbsp;This prevents two or more users from making changes to the same record at the same time, which can create problems and confusion.<br>The problem comes in when a user opens up the database to a given record and walks away from the computer, or just leaves it sit there idle.&nbsp;&nbsp;This means no one else can edit that record either.<br> <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[JimConrad]

Watch out for Edited Record option.&nbsp;&nbsp;Unfortunately Access does not lock individual rows of the database.&nbsp;&nbsp;It locks &quot;pages&quot; which are sets of 2000 bytes.&nbsp;&nbsp;So if you have a small table (just a few columns of data), you might have 10 rows of data sharing a page.&nbsp;&nbsp;Locking any row causes all the other rows in that &quot;page&quot; to also be locked. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>

 

[famousb]

thanks for the tip Jim, i never knew that. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>