This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
You can't insert an explicit number since it is an AutoNumber field. To insert a new row, either leave the autonumber field out of the insert clause OR set it to a value of 0. In either case, Access will automatically insert the next number.
For example, if you have table "table1" with columns: (id autonumber) and (field1 char(20)), then here are the 2 inserts you can choose from: 1. insert into table1 (field1) values ("some text") // id column left out OR 2. insert into table1 (id, field1) values (0, "some text") // id set to 0
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"