I have an IP2003 form that queries an access database (one table). The form looks for the oldest invoice and presents to the agent to make a payment, the agent updates the form and submits to the database then proceeds to the next invoice.
The problem is that I have 10 - 15 users at any one time and sometimes they are accessing the same inoice. Any ideas how I can get around this?
Cheers