Change starting value of autonumber field

[mbaddar]

Hi,

Does anyone know the easiest way to change
the starting value of an autonumber field in Access?

Thanks,

MBaddar

 

[mbaddar]

I found a nice way of doing this for anyone that runs
into the same problem. I copied the table whose
identifying number I wanted to autoincrement.
I deleted all the rows from the copied table except
the last one. Then, I changed the datatype of the field
I wanted to increment from autoincrement to number.
After doing this, I appended this table to the original
table.

This did the trick.

MBaddar