2 users adding records at the same time? (1 Viewer)

[iamratman]

Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry.

I am wondering if this would cause a problem for the auto numbering for the ID field.

 

[Pat Hartman]

Computers run so fast that it seems like multiple things ae happening at once. However, in a single CPU system, the process is completely serial. Just incredibly fast.

Access handles the potential problem with autonumbers by assigning and committing the autonumber as soon as a record is started. Since the process is serial, it is not possible for two inserts at exactly the same time. They are always offset by a small margin. The upshot of this is that if a record isn't actually saved, its autonumber will be lost, leaving a gap in the sequence. Many novices are disturbed by this but it really isn't a problem. The only use for an autonumber is to provide a unique identifier for a record.

 

[iamratman]

ok so i guess it shouldnt be a problem for a couple of data entry stations to the one table.

thanks Pat.