Strange Primary Key values

[aine_canby]

Hi,

I have created a form based on a table using the wizard. This table
has a primary key field plus a few more. When I add new rows to the
table using the form, I gets strange primary key values such as
-298239823. Any ideas why this might be?

Thanks,

Aine

 

[Douglas J. Steele]

Sounds as though your primary key is an AutoNumber set to Random, rather
than Sequential.

That shouldn't matter: the value of an AutoNumber key has no meaning.

 

[Allen Browne]

Doug is probably right, but if it's not set to Random, see:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html