Hi. First, it doesn't matter what view you're in, as long as the 'delete all records' command is available.
Second, what you might want to do instead is save a copy as a clone. That's an empty database with the data only removed.
I'd use one of two methods for scripting the deletion of all records from all tables if that's what I really needed to do.
1. For each base table, have the routine go to any layout based on that table; find all; delete all; continue to the next table.
2. set-up a cascading delete relationship some way that (safely) accomplishes the deletion of all data by simply deleting one record.'
For instance, in every table, set-up a constant field (numeric calc = -1). Set-up a special base table only for performing this delete,
and include in it a number field. set-up a cascading delete relationship ('delete related records' option on) from this field to the
-1 constant field in all other tables (one relationship for each table). To perform the delete all function, create a record in the special
talbe, then set the number field in the special table to the value -1. Delete that record and all records in all other tables will
be deleted in one large domino effect.
I anticipate this script woudl be run only by a full access account user or with the 'run with full access' option checked.
Thanks I think I got what your doing, I was hoping there was like a right click delete all records option in "Manage Database" window where it lists all the tables. All I see is the option to delete the table only. Thank you.
All data, all tables? Save As Clone.
Hahah I just realized Erik said the same thing, but for some reason when I read it I didn't understand what he was talking about. Awesome thank you guys thats exactly what I was looking for! Appreciate it!
Feature Request: We need a Save as Clone for just ONE Table
> All data, all tables? Save As Clone
Its easy enough to just copy the table from a regular clone isn't it?
Ron Smith, MD, 'The Pediatric Guide For Parents'
Want to know more about me and my family? Take a look at the free ebook about my daughter below.
Forever And A Day For Laura Michelle