01-08-2001, 01:25 PM
I have an Access database that contains a field that stores an order id number when an order is placed. The field is auto incrementing. However, on more than one occasion I have seen two different tickets with the same number. How can this be and how can I avoid this ever happening again?