Access 2000

  • Thread starter Thread starter Ellen Seibolt
  • Start date Start date
E

Ellen Seibolt

Here's the problem: The database will not allow new
records. I'm guessing that it has to do with the
autonumber feature. The autonumber will not incrementally
increase beyong 6476 and reverts back to a 5320 number
that has already been used and therefore the db won't
accept the new record. Can you help someone that knows
nothing about access?
 
Here's the problem: The database will not allow new
records. I'm guessing that it has to do with the
autonumber feature. The autonumber will not incrementally
increase beyong 6476 and reverts back to a 5320 number
that has already been used and therefore the db won't
accept the new record. Can you help someone that knows
nothing about access?
Click to expand...

When an Autonumber gets to 2147483647 it loops around to -2147483648
and starts counting up.

You've probably got two problems: one, there is an updated version of
MSJET which you should download from Microsoft's website and install.
There has been a persistant bug in this, the database engine for
Access .mdb databases; it may or may not be fixed at this point.

The second - having the autonumber seed reset - may require trying a
couple of solutions. First, try creating an Append query to append a
single record to the table with 6476 as a Long Integer appended into
the autonumber field (you can then delete this record). See if it now
takes up autonumbering with 6477.

If that fails, I'd create a new, empty database; import all the other
tables in their entirity, and then this table, DESIGN MODE ONLY, into
it. Use File... Get External Data... Link to link to the old table and
run an Append query to append all the records.
 
Back
Top