Is there a faster way besides viewing the data in table view and manually deleted the records? Appreciate the help.
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
Retrieving data ...