Auto Number. Won't let user enter new record

[Guest]

Hello,

We have a scenario where the client is multi user, server holds back end
tables, and several front ends. Client is wireless. Users can enter records
in a Data Entry form, then suddenly can't. Access gives the message that it
would create a duplicate record. Somehow the auto number reverts back to
number 1 which is already assigned. We have created a query to fix this,
which sets the auto number to the correct one. However, it seems to happen
quite frequently to this client. Is it because they are wireless?

Any help appreciated
Connie

 

[Paul Overway]

This stems from a problem with the seed value for the field. Which can be
fixed using code from the following link:

http://allenbrowne.com/ser-40.html

You should also make sure that all users are running the latest service pack
for Jet 4.0, because this issue occurs more frequently in the earlier
releases.

More importantly, you shouldn't use an Access/Jet database over a wireless
network connection. It is very likely that you'll experience corruption
problems. Access requires a stable network connection, and wireless
connections are by nature unstable. Keep in mind that you are opening a
file that is often larger than a typical document...plus a locking file
(ldb) which keeps track of connections to the database. Lost packets during
critical momements (i.e., saving a record) will often cause corruption.