[thelist] Truncate Table In MS Access
rudy
rudy937 at rogers.com
Sun Sep 28 10:52:01 CDT 2003
> Does anyone know a way to truncate a table as you would in SQL Server
> using the TRUNCATE command?
i don't, but that doesn't mean the way does not exist
the only way i know of is an unqualified delete
delete from yourtable
> I have a table where I have to reset the autoincrement number so that it
> starts with one after deleting all the rows.
delete all the rows, then compact the database -- that resets the number
rudy
More information about the thelist
mailing list