[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