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.
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.
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....
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
