<div>
If this is an occasional thing, you could just open each table, select All (Ctrl + A) and delete.<br />
<br />
Careful about deleting data from tables, its kind of permanent, don't make a button too easy and without plenty of warning.
</div>


If this is an occasional thing, you could just open each table, select All (Ctrl + A) and delete.

Careful about deleting data from tables, its kind of permanent, don't make a button too easy and without plenty of warning.

<div>
Home eghtebas. &nbsp;Works a treat (and thanks for the tip re table with many.<br />
Best regards, Lisa
</div>


Home eghtebas.  Works a treat (and thanks for the tip re table with many.
Best regards, Lisa

<div>
My pleasure.<br />
<br />
Also, for future reference:<br />
<br />
CurrentDB.Execute &quot;Delete * From [C:\Folder1\TestFile.mdb].<wbr />[Tabl1]&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
could be executed to manipulate TestFile.mdb remotely.<br />
<br />
Mike<br />

</div>


My pleasure.

Also, for future reference:

CurrentDB.Execute "Delete * From [C:\Folder1\TestFile.mdb].[Tabl1]"
                                               
could be executed to manipulate TestFile.mdb remotely.

Mike


<div>
<div class="content wysiwyg-content">
Hi experts,<br />
I need a way to clear records from a data table (maybe a macro) - intended to use as a rollover of a database for a new cycle. &nbsp;More than one table needs to be cleared, so I'm guessing a separate macro would be needed for each table - or can this be achieved with just one process?
</div>
</div>


Hi experts,
I need a way to clear records from a data table (maybe a macro) - intended to use as a rollover of a database for a new cycle.  More than one table needs to be cleared, so I'm guessing a separate macro would be needed for each table - or can this be achieved with just one process?

Macro that will clear data from table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.