How to Delete All Records from MDB Database Table In VB 3.0 (113390)
The information in this article applies to:
- Microsoft Visual Basic Standard Edition for Windows 3.0
This article was previously published under Q113390 SUMMARY
This article shows by example how to delete certain tables from a Microsoft
Access database (.MDB file) by deleting the TableDef.
You could also use this method to delete all the records from a table by
first finding the TableDef and then compacting the database. This method
may be faster than: - Deleting all of the records one by one.
- Using the action query Delete method.
The following example uses a four-step process to quickly delete all
the rows in a table: - Find a specific TableDef.
- Delete the TableDef.
- Compact the database.
- Add an empty TableDef back to the database.
Modification Type: | Minor | Last Reviewed: | 1/8/2003 |
---|
Keywords: | KB113390 |
---|
|