[AccessD] Reset Autonumber (WAS: Autonumber AssignedImmediat ely)

You can do a quite a bit using ADOX too -- but can't get into ElementK's
site to get a link to the article. :( ADOX lets you do a few things
programmatically that you can't do manually. 

Susan H. 

That's it!

 
I use a Data-Definition SQL statement:

ALTER TABLE TableName ALTER COLUMN AutoField COUNTER (1,1); 

The first number is the starting value, and the second is the increment.

This works for A2K and later.