reset autonumber ?

[ooops]

This is what I have but I keep getting runtiem error "3211"
The database engine could not lock table 'myTable' because it's already in use by another person or process.

With DoCmd
.SetWarnings False
.RunSQL "Delete * from myTable"
.SetWarnings True

.Rename "myTable_old", acTable, "myTable"
.CopyObject , "myTable", acTable, "myTable_old"
.DeleteObject acTable, "myTable_old"
End With

 

[ooops]

I know why already. Thanks.

 

[zonzon]

i have this problem, 3211, i looked all my code and nothin seems to lock the table,

what is it the possible cause for this 3211 error code?