<div>
True row locking is not possible in Access... <br />
but you might look into the Pessimistic locking for records...<br />
<br />
CHeers
</div>


True row locking is not possible in Access...
but you might look into the Pessimistic locking for records...

CHeers

<div>
angellll,<br />
&nbsp; &nbsp; What d ya mean by Pessimistic locking for records...<br />
<br />
Thnks in advanced<br />
<br />
Ezree
</div>


angellll,
    What d ya mean by Pessimistic locking for records...

Thnks in advanced

Ezree

<div>
Since June... <br />
<br />
Questions Asked 12 <br />
Last 10 Grades Given A B &nbsp;<br />
Question Grading Record 2 Answers Graded / 2 Answers Received
</div>


Since June...

Questions Asked 12
Last 10 Grades Given A B  
Question Grading Record 2 Answers Graded / 2 Answers Received

<div>
<div class="content wysiwyg-content">
Hi all,<br />
&nbsp; &nbsp;I'm using MS Access as my database, I want to make the MS Access to be shared in a small LAN (2-3 workstation). Is it possible to do a row locking using MS Access. So other people is not allowed to do update (except query) when other people is doing updating. Or is there any other way to control my database. I'm developing my application using Visual Basic. <br />
<br />
<br />
Thanks in advanced<br />
<br />
Ezree
</div>
</div>


Hi all,
   I'm using MS Access as my database, I want to make the MS Access to be shared in a small LAN (2-3 workstation). Is it possible to do a row locking using MS Access. So other people is not allowed to do update (except query) when other people is doing updating. Or is there any other way to control my database. I'm developing my application using Visual Basic. 


Thanks in advanced

Ezree

MS Access row locking

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.