Access: Getting 0 as first num in AutoNumber field

Hi,

I know this isn't strictly a VB question but I am writing a program in VB which interacts with an MsAccess DB.
My problem is that I have an Id field which is of type AutoNumber. No matter what I've tried, Access doesnt seem to like the number 0 in its autonumber fields. Does anyone know a way around this problem? I would be very grateful for any suggestions.

Paddy

Are you trying to manually enter a value into the AutoNumber field? Access won't allow you to manually enter a number into the autonumber field.

And it ALWAYS starts with 1. Never 0.

Yea thats what I figured. You can append from another table and get your autonumber to start at any positive number you like, but if you try getting it to start with a negative number the next number always jumps to 1 (skipping 0 completely). Its a pity because my user is insisting on using 0 as an Id number and it looks like it cant be done in access.

thanks anyway, Paddy