Access97 Record Locking

[katz]

Hello Panja, John W. Vinson[MVP], All

I'm sorry, I didn't mean RecordNo, I meant record ID like OrderID 1001,
1002, 1003 etc. I'm using a counter to create new order ID's depending on
how many records that will be added.
I would like to lock the table in the beginning of the processing and give
a message to any user who wants to add new records until I'm done.
And release the lock when I'm done.

Thanks, Abe katz

 

[John Vinson]

Hello Panja, John W. Vinson[MVP], All

I'm sorry, I didn't mean RecordNo, I meant record ID like OrderID 1001,
1002, 1003 etc. I'm using a counter to create new order ID's depending on
how many records that will be added.
I would like to lock the table in the beginning of the processing and give
a message to any user who wants to add new records until I'm done.
And release the lock when I'm done.

Thanks, Abe katz

That's exactly what my suggestion will accomplish. To repeat:

That said... open a Recordset exclusively. Look at the VBA help for
the OpenRecordset method. If you open it, add your records, and then
close it, your numbers should be sequential within that block (no
guarantees about gaps outside the block though).


I don't know what "processing" you intend, but I presumed from the
context that you're using VBA code to enter records... is that not
correct? Did the suggestion help, or if not, what seems to be missing?

John W. Vinson[MVP]

 

[S Panja]

Dear Katz

You originated this on 10-06-05; why a separate thread now? Things become
ever so murky if so broken.