On Dec 11, 7:20 pm, "ABRAHAM GOLDSTEIN"
wrote:
run access 2003 works fine.while synching one of the files to the palm
it looks like the auto numbers has gotten corrupt. the last 2 numbers where
665-666.
and all of sudden 98176657-98176658. on the desktop

If you are concerned about duplicates then put a unique constraint on
the Autonumber column; if you think you already have a unique
constraint then double check because there is/has been a bug in Access
where the unique constraint (or is/was is just PRIMARY KEY?) gets
dropped.

You should be unconcerned about the actual values generated; even if
the sequence has skipped 10 million values there will remain more
available values than you could ever use. If you are concerned about
actual values then it is likely you have a design flaw e.g. exposing
Autonumber values to users.

Jamie.

--