Delete all record from an Access table using VBA

G

Guest

I have a work table that I have to clear before my next run. In SQL I used
truncate to empty it. This doesn't work in Access VBA. Does anyone know a
quick way to empty a table in VBA without looping through and using tb.delete?
 
D

Dirk Goldgar

databaser said:
I have a work table that I have to clear before my next run. In SQL
I used truncate to empty it. This doesn't work in Access VBA. Does
anyone know a quick way to empty a table in VBA without looping
through and using tb.delete?
Click to expand...

CurrentDb.Execute "DELETE FROM MyTable", dbFailOnError
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Record insert/delete anomaly 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Using a VBA Variable function from Access table data in Access que 5
Can I use a variable for a table name in an SQL statement using VB 2
Access Table Import with VBA 2
Can I use a variable for a table name in a SQL statement using VBA 1

Top