Using an Access Database

Oh.. and if you don't want it to auto-increment (the id field), you'll need to keep track of it yourself...

SELECT max(id) from person

and then add one to that value when you insert...

Using an automatic counter is less hassle :-)