reset autonumber

[slimjen]

All; I have some code to delete all data from a table, then reload it with an append query. Is there a way to reset the autonumber of the table I am adding the data to when it is empty? Thanks

[June7]

Bing: Access reset autonumber

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

[slimjen]

I'm trying to do this during executing my code after I delete the data from this table:

Dim strSql As String
strSql = "ALTER TABLE tblMstr ALTER COLUMN ID1 COUNTER(1,1)"
DoCmd.RunSQL strSql

I get invalid field type.

[June7]

That doesn't appear to be what is described in the link. I doubt can do this with ALTER sql.

Run Compact & Repair to reset empty table autonumber.

[Missinglinq]

Here's a link to two methods:

http://access.mvps.org/access/tables/tbl0005.htm

Linq ;0)>