[thelist] Truncate Table In MS Access

Joel D Canfield joel at spinhead.com
Sun Sep 28 10:38:47 CDT 2003

> Does anyone know a way to truncate a table as you would in 
> SQL Server using the TRUNCATE command? I have a table where I 
> have to reset the autoincrement number so that it starts with 
> one after deleting all the rows.

Not a direct answer, but resetting an Access autonumber field is still a
tedious, roundabout, manual affair.

Is it possible to just *delete* the table and re-create it on the fly?


More information about the thelist mailing list