Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

More than one user using database

Status
Not open for further replies.

cjany

IS-IT--Management
Nov 3, 2004
72
US
I have a simple database that I share with another user. The problem is if she is adding records to the table at the same time I am, some records are overwritten. I have a record count field that increments with each new record. How can I lock in the record that I'm updating so that the other user can continue with the next record?
 
Take a look at this thread. faq181-1023
or search the FAQ's for autonumber for other methods.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top