[thelist] Truncate Table In MS Access

David Mitchell dave at dbmdata.com
Sun Sep 28 09:08:50 CDT 2003


Hi All,

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.

Thanks,

Dave

/**
David Mitchell
dave at dbmdata.com
www.dbmdata.com
*/ 

MortgagePro.ca
Now accepting online applications!
http://www.mortgagepro.ca



More information about the thelist mailing list