ADO: Delete All records at once

[Franky]

Hi,

what is the best way to delete ALL records in a recordset?
I would like to know it in ADO and how i can use for it a SQL-command.

Franky

[axion_sa]

For Access:
DELETE FROM TableName [WHERE (Condition)]
For SQL Server:
TRUNCATE TABLE TableName

[Franky]

Thanks for the fast reply
This I knew already, hehe .......

But I want to make it in an ADO way.


Franky

[peet]

you can use axion_sa way, using ADO... or am I missing something here ? (would not be the first time )

sConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb"
    cnn.Open sConnString
    cnn.Execute "DELETE FROM TableName [WHERE (Condition)] "

[oh1mie]

How you get that work with Access, i cant ?
(It works great with SQL Server but Access)

db.execute "delete from table.....
I need to use
dbexecute " delete * from table.....

[peet]

Originally posted by oh1mie
How you get that work with Access, I cant ?
(It works great wit SQL Server but Access)

db.execute "delete from table.....
I need to use
dbexecute " delete * from table.....

you are abs. right oh1mie.

[axion_sa]

whoops my bad