Deleting Records (VB ver6)

Topic

New Reply

Hi,

How to delete all the records in a table? Thanks…

Reply | Quote

Replies

Are you using ADO to access a database table? Are you editing a table in a Word document? More info please…

Reply | Quote

I’m using ADO to access a database table. Only managed to delete by record. Try to delete all the records in the table. Thanks…

Reply | Quote

To delete all records from a table, set the CommandText for your ADO Command object to something like this:

DELETE * FROM MyTable

Just in case I’m completely out to lunch, I’m moving this to the Access board, where the ADO gurus hang out.

Reply | Quote