Delete records in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K - 22 Nov 2006 22:12 GMT

Good day,

How do I delete all the records in a table without deleting the table itself
via Macro.

Thanks in advance

Reply to this Message

Douglas J. Steele - 22 Nov 2006 22:23 GMT

CurrentDb.Execute "DELETE FROM MyTable", dbFailOnError

(replace MyTable with the actual table name)

(Note that if you have referential integrity turned on, you have to ensure
that you delete the data in the correct order)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Good day,
>
[quoted text clipped - 3 lines]
>
> Thanks in advance

Reply to this Message

K - 22 Nov 2006 23:05 GMT

Thanks for the response. All I did that worked for me was created a Delete
Query. Simple and quick.

Cheers

> CurrentDb.Execute "DELETE FROM MyTable", dbFailOnError
>
[quoted text clipped - 10 lines]
> >
> > Thanks in advance

Reply to this Message