M
mscertified
I thought this would prove an interesting challenge, unfortunately, so far it
has proven an impossible challenge.
Problem: A web page is inserting records to a table. Multiple users are
pulling records from this table (read/process/delete). No user must get the
same record.
My latest attempt (my third try) using a recordset with dynamic cursor and
pessimistic locking resulted in a 'multiple users are attempting to update
the same data' message. Has anyone done anything like this?
has proven an impossible challenge.
Problem: A web page is inserting records to a table. Multiple users are
pulling records from this table (read/process/delete). No user must get the
same record.
My latest attempt (my third try) using a recordset with dynamic cursor and
pessimistic locking resulted in a 'multiple users are attempting to update
the same data' message. Has anyone done anything like this?