Hello.
How can I delete all the records of a certain table using a query, a macro,
or even a procedure module?
Thank you for the effort.
Best regards.
Delete * From TableName;

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
> Hello.
> How can I delete all the records of a certain table using a query, a
> macro,
> or even a procedure module?
> Thank you for the effort.
> Best regards.
acores - 25 May 2007 12:35 GMT
That worked really fine, thanks.
> Delete * From TableName;
> > Hello.
[quoted text clipped - 3 lines]
> > Thank you for the effort.
> > Best regards.