"Reggie Laffond" wrote in
:


So I simply imported the tables into Access 2000 for the back end and


I have just discovered that one of my tables had
reset the next autonumber value to 1.

Questions:
How could this have happened?

If you import a table _structure_ then the seed will start from scratch.
If you imported the table with its data then the seed will fall back to
(highest existing autonumber + 1). In effect you are just creating a new
table.

I had repaired
and compacted the front and back ends

Compacting a db with one or more empty tables will reset the autonumber
in that table or those tables.

I don't understand how it matters, though. If you want to start with an
empty database, then it's appropriate to let all counters restart. If you
want to start with a seeded database, then you will need some method of
initialising it, which in turn means that you think very carefully about
what data you need to import, in what order, and how. This is a technical
procedure called Data Migration.

All the best


Tim F