access 2000 record locking in a queue
I have several copies of a vb app processing messages stored as records in a
table in an access 2000 db. The app communicates with the db using ado.
I would like to have some way of ensuring that each record is processed by
only one copy of the app, i.e. processed only once, and then marked as
processed. I suppose I need some sort of record locking, and have seen ways
to do this in Oracle or in SQL server but not in Access.
Does anyone have any suggestions?
I don't scan this group regularly, so please reply to my email address.
Thanks in advance for any advice.