Access Table primary key goes to 0 after 9999

  • Thread starter Thread starter James
  • Start date Start date
J

James

I need help please. I am working wiht a Access 2003 table that I did not
creatre but I need to do my new job. The problem I have is we just hit record
number 9999 in the primary key field and that is also our tracking number and
after 9999 the number went to 0 and now says it can not create a new record
becasue it would be a dulicate. In other words it thinks 10001 is record 1.
Any idea whay it will not go past 9999?
 
What datatype is your primary key field? It will usually either be a long
integer or an autonumber.

Is this happening when you run your application? If so, there could be some
code that resets the tracking number when it reaches 9999, although I cannot
for the life of me figure out why someone would do that.

What level of access do you have access to the database? Can you open the
table in table view? If so, are you able to insert a new record by entering
data directly into a table (STOP, I SAID STOP! Make a copy of the back end
database and try this with the copy, not the original).

Dale
 
When you copy a value into the primary key field of a linked
table, it resets the next primary key value. So if you copied a
zero record into the table, the next value would be 1.

This behaviour is not in the help files because it is a 'fix' for the
previous attempts to get Autonumbers to work correctly.

All older versions of Access 2000, 2002, 2003 are broken,
and you can get errors in the autonumber keys.

The other posibilities are that you have an older version which
is broken (make sure that you have applied all Office patches),
or that you have code which explicitly resets the autonumber
after 9999.

(david)
 
Back
Top