Change the auto-increment in Access

Hi all,

Hopefully this is an easy question for one of you gurus. I have an auto-increment field, and I would like the start value to be different than 1 (Because it will later be migrated to SQL Server, along with another database collecting the same data, and we don't want to end up with duplicate keys). Any thoughts or assistance are appreciated.

Thanks in advance for the help!

Not a biggie...just manually change the number of the last record...add one more if you like and then erase the contents...
and you'll get a new start number...higher that 1...