Emptying a database of data

[Lou_Reed]

Is there way to empty a an MS Access 2010 database of its contents in one easy keystroke?


I am trying to check my database and I think that an easy way to do that is by starting over
is repopulating it wit data.

Any help appreciated. Thanks in advance.


Respectfully,



Lou_Reed

[JoeM]

You can create a Macro that will delete each of your data tables.
Basically, you would use the "RunSQL" Action, with a command like this:

DELETE [TableName].* FROM [TableName];

You would need one of those actions for each table you have.
I would also recommend adding a "SetWarnings" action at the top set to "No", and one at the bottom set to "Yes". This would suppress all those warning about deleting the records in each table.

If you are not opposed to VBA, you could do all tables at once with VBA code, like the code shown here: http://stackoverflow.com/questions/6...tables-at-once

[CJ_London]

assuming you have your tables in a backend (and if not, this is a good time to start), create a new blank db and import all the tables to create that backend - under options, choose 'definition only'. Not one keystroke, but only a few clicks of the mouse and a lot quicker to run than deleting contents