[thelist] Truncate Table In MS Access

[Joel D Canfield]

> 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?

spinhead