Conceptual Problem with DAO/ADO Recordset
 

Hope someone can clear my thought. Thanks in advance.

I have the following table keeping all available document numbers for my
application.

Document / Num
-------------------------
Invoice / 1230
Receipt / 451

Currently, I am using SQL SELECT query to obtain the number and then utilize
SQL UPDATE query to increase the number by one. I am always worried about
somewhere between the two queries, there is a slight possibility that
someone else would obtain the old number (before the UPDATE query is
executed). So I am thinking of using a recordset to take control of the
table (ideally at the record). This way, I can read the number and increase
it by one altogether. My question is how MSDE and JET 4.0 (because I am
using both ADO and DAO) will handle the recordset when there are two
recordsets (two PCs) trying to access the table. Will MSDE / JET 4.0 arrange
the later one to wait and process it after the first one is clear. Or will
they just return an error to the later recordset.