Duplicate "AutoNumber" being generated in form???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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...
Click to expand...

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
 
Back
Top