Hi there,

Any time I use Access, I always use the Autonumber field with the default seed value (1). What I want to do is start the numbering at a different value for a particular table I'm generating (in this case, 500); this is actually the first time in 7 years that I've had this come up, if you can believe that.

Unlike SQL Server, I don't see a spot to adjust the seed value. So...other than creating 499 fake records, how would I?

Thanks.

In the table's design mode, there's a tab control at the bottom of the screen, with basic and advanced options for each field. I think you can set the autonumber's seed under the advanced section.

Or, you could use a SQL command to drop the existing column and build a new one with a seed.

http://support.microsoft.com/kb/287756

method 2 should work

Thanks, Forrest and Chris. Forrest: it was your second idea that worked. You can't actually modify the identity seed value in any of the field properties like you can with SQL server; however, you can create a table using an SQL query and ASP that will allow you to set the seed value, which is what worked for me.

Glad to hear it. Turns out SQL commands aren't worthless in Access after all.