Duplicate "AutoNumber" being generated in form???

[Guest]

All,
I have an Access Db w/ mulitple data entry users. Why am I getting
duplicate "AutoNumber" for records in form view. Once the form is closed and
the data is stored in the table, it generates another AutoNumber (ID) for the
record. Here's my problem, the db is for name tags for an expo and the
AutoNumber (ID) needs to be unique for each record b/c that's how the tag is
being tracked through the expo. The data entry in the form is creating a
name tag with an "ID" assigned to each persons. Please assist...

 

[John Vinson]

All,
I have an Access Db w/ mulitple data entry users. Why am I getting
duplicate "AutoNumber" for records in form view. Once the form is closed and
the data is stored in the table, it generates another AutoNumber (ID) for the
record. Here's my problem, the db is for name tags for an expo and the
AutoNumber (ID) needs to be unique for each record b/c that's how the tag is
being tracked through the expo. The data entry in the form is creating a
name tag with an "ID" assigned to each persons. Please assist...

There was a bug in some versions of Access causing duplicate
Autonumber values to be assigned after you Compact the database: see

http://support.microsoft.com/default.aspx?scid=kb;en-us;257408

I'm not *certain* that this is your problem though. You say "once the
form is closed... it generates another autonumber"; that's not
typically how Autonumbers work! Do you generate the numbers yourself
in code instead? What are the relevant tables, and what autonumber are
you trying to put on the tag?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps