delete all records but keep table

's Computer Specifications

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?

's Computer Specifications

Create a macro with the RunSQL action.

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

--
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.

"Eddy" <(E-Mail Removed)> wrote in message
news:CE8A289F-4D76-466A-AAD7-(E-Mail Removed)...
>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?

's Computer Specifications

Eddy wrote:
> 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.

--
Joseph Meehan

Dia 's Muire duit

's Computer Specifications

Thanks for helping newbie! Exactly what I need.

"Allen Browne" wrote:

> Create a macro with the RunSQL action.
>
> The statement to delete all records from Table1 is:
> DELETE FROM Table1;
>
> --
> 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.
>
> "Eddy" <(E-Mail Removed)> wrote in message
> news:CE8A289F-4D76-466A-AAD7-(E-Mail Removed)...
> >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?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete records from table 1 which match records from table 2	Matilda	Microsoft Access	7	26th Mar 2009 11:25 PM
Delete query unable to delete records from table. Fix how?	=?Utf-8?B?TG9uZ1RvbQ==?=	Microsoft Access Queries	8	15th Apr 2007 11:29 AM
how do you delete records or update records in a link table.	=?Utf-8?B?SGVscG1l?=	Microsoft Access Queries	2	18th Aug 2005 05:12 PM
Delete Query - Delete records in Table 1 using parameters from Tab	=?Utf-8?B?SmVu?=	Microsoft Access Queries	2	21st Mar 2005 01:13 PM
How to delete records from the original table while randomly selecting the records	CaribSoft	Microsoft Access Queries	2	5th Feb 2004 09:53 AM