Access is similar to the truncate statement in SQL Server.

Access is similar to the truncate statement in SQL Server.
1. Table Name: mytable auto-increment column: myid
2. Delete from mytable; (delete data first)
3. alter table mytable alter column myid counter (); (corrected auto-incrementing column)
When executing this sentence, the system prompts: The field data type is invalid. It is strange that I deleted the table, re-created it, and executed it normally.
4. Access cannot execute two statements at the same time and must be executed in one statement.

In access, the create auto-increment column (the first parameter is the initial value, and the second parameter is the step value), text field, and integer field.
Create Table mytable1 (myid autoincrement (1,1), mytext varchar (50), Myint INT );

Delete table
Drop table mytable;