Autonumber Question

G

Guest

I have a multiuser database that uses the ProjectID field (an autonumber
field) to create the project number for every new project. Some users are
complaining that when they attempt to input a new project, they are receiving
an existing project number as the "next number" and since the database is set
up so that all the ProjectID's must be unique numbers, it will not allow them
to create the new project entry. Is this happening because there are
multiple users in the database who may also be creating new projects? If so,
is there some code I can place into my input form that will "release" or free
up the next available number for the concurrent user?
 
G

Guest

You can't "free up" the next number is it is already in the table. And, yes,
it is possible the multiple users creating projects can cause this problem.
This is not a simple solution. I would suggest looking at the Multiuser
group for suggestions on handling concurrency as well as finding some good
reference material on the subject.
 
J

John Spencer (MVP)

What version of Access? I seem to remember that this was a problem with early
versions of Access 2000. If you are running 2000, have you tried updating it
with the service packs?
 

Ask a Question

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.

Ask a Question

Top