Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
query a recordset | Excel Discussion (Misc queries) | |||
return recordset | Excel Discussion (Misc queries) | |||
Looping Through A Recordset | Excel Programming | |||
Looping Through A Recordset | Excel Programming | |||
ADODB Recordset | Excel Programming |