Autonumber versus Number + 1

[ReidarT]

Is there any problem using autonumber in a table in a network environment?
regards
reidarT

 

[MacDermott]

AFAIK, as long as you are using autonumber appropriately (to supply a unique
identifier, not to have any intrinsic meaning), using it in a networked
environment should not be an issue.

 

[david epsom dot com dot au]

Is there any problem using autonumber in a table in a network environment?

Autonumber primary keys will not allow you to have lots of people adding
records at the same time. You should plan something else if you are ever
going to add more than 1 record every few minutes.

or, to put it another way:
Access/Jet is a distributed database engine, with high latency.

(david)

 

[MacDermott]

With all due respect, I've never run into this aspect of Access before.
Could you perhaps explain this a bit more?

- Turtle

 

[david epsom dot com dot au]

With all due respect, I've never run into this aspect of Access before.

HOWTO: Implement Multiuser Custom Counters in Jet 4.0 and ADO 2.1
http://support.microsoft.com/default.aspx?scid=kb;en-us;240317

Duplicate autonumbers
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&[email protected]

Autonumber behaviour question
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=OXvEkdsKBHA.1628@tkmsftngp05

I don't expect to see problems unless you try to add two
records AT THE SAME TIME, which you avoid for a start by
not holding new records open, and the actual latency is
around 5 seconds, not 5 minutes, but if I was giving advice
to a stranger....

(david)