delete all records but keep table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eddy - 23 Mar 2007 14:16 GMT

I need to delete all records in a table but keeping the table. This is to
allow new records to be push into the table by my IT admin (he is not
familiar with Access). Can't do appending data as past weeks data may
change. Any suggestions?

Reply to this Message

Allen Browne - 23 Mar 2007 14:30 GMT

Create a macro with the RunSQL action.

The statement to delete all records from Table1 is:
DELETE FROM Table1;

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I need to delete all records in a table but keeping the table. This is to
> allow new records to be push into the table by my IT admin (he is not
> familiar with Access). Can't do appending data as past weeks data may
> change. Any suggestions?

Reply to this Message

Eddy - 23 Mar 2007 14:47 GMT

Thanks for helping newbie! Exactly what I need.

> Create a macro with the RunSQL action.
>
[quoted text clipped - 5 lines]
> > familiar with Access). Can't do appending data as past weeks data may
> > change. Any suggestions?

Reply to this Message

Joseph Meehan - 23 Mar 2007 14:33 GMT

> I need to delete all records in a table but keeping the table. This
> is to allow new records to be push into the table by my IT admin (he
> is not familiar with Access). Can't do appending data as past weeks
> data may change. Any suggestions?

Use a delete query.

Signature

Joseph Meehan

Dia 's Muire duit

Reply to this Message