I'm having a problem with my autonumber. Whenever a new record is created, it increments the ID by 2, not by 1. So my frist 4 records are: 1,3,5,7 (not 0,1,2,3). As far as I've seen, I can't set the increment number to 1 (it seems to be defaulted to increment by 1 all the time). Anyone know anything about this problem?

Where are you creating the new records? It may not be an issue with the table but with the object you are using to add the data into the table with. Maybe you are generating a blank record with that object, but it is not being saved.

I wouldn't be so wishy-washy. Random-Access, your code is consuming a second autonumber. Check your code. Look for code in the form's AfterUpdate event or close event, possibly the Current event.