[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?
spinhead
More information about the thelist
mailing list