Erase many tables

[Bradley C. Hammerstrom]

Access2000

I want to avoid creating a separate delete query for each table I want to
"blank-out", but when I include more than one table in the query Design Grid
(even though the tables are not related) I get a "cannot delete from
specified table" error when I try to run the query.

Brad H.

 

[John Vinson]

Access2000

I want to avoid creating a separate delete query for each table I want to
"blank-out", but when I include more than one table in the query Design Grid
(even though the tables are not related) I get a "cannot delete from
specified table" error when I try to run the query.

That's correct. You can't do it that way.

Why on Earth are you routinely blanking out tables anyway!?

I'd suggest writing a Macro or a small VBA routine to call a series of
delete queries. But you can't do it all in one query.

 

[Bradley C. Hammerstrom]

John V,

FYI, I do have a macro that opens all the delete queries, one by one. Just
looking for a shortcut.

And the reason I need to routinely delete all records from many tables is
that my database is used independently on many separate projects with
unrelated data (photos). And since I am forever developing improvements into
each sucessive project's database, I need to copy the db and delete all the
data so that I can use the improved version like a template for the next
project.

Thanks as always,

Brad H.

 

[Van T. Dinh]

Split your database to front-end and back-end. You can do most developments
on the front-end unless you want to change the Table Structure.