Discussion Locked

Access 2000 - AutoNumber

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I disable the AutoNumber on Access 2000 when starting a brand new database?

7 replies

by david

Make your ID field a number format not autonumber.
Also there are some user defined field names that prompt access to use as a key field eg ending with ID try using a different name for that field
As the other people have suggested say no to the prompt for primary key when saving the table.

This discussion is closed to new replies.