You probably need three queries, one for each table. They can be run in
sequence from a Macro or from VBA code.
If you have cascading deletes set up on the relationships between your table -
e.g. tblHorses is related one to many to tblOwners, with the Cascade Deletes
checkbox set, and similarly for tblInvoices - then deleting a record from
tblOwners will delete all the records for that owner from the other two
tables. It won't "delete the content of the fields" - it will remove the
entire record leaving no trace that it was there.
(Be sure you have a backup!!!!! Deletion is a one-way street!)
Well actually I have 25 tables and want to delete the contents of 20 of them
to form a empty database that my friends can use without my data in it, so i
should still look at cascade delete...Thanks bob
Well actually I have 25 tables and want to delete the contents of 20 of them
to form a empty database that my friends can use without my data in it, so i
should still look at cascade delete...Thanks bob
Create a new empty database, and use File... Get External Data... Import to
import all 25 tables. For the ones you want empty, check the box "design view
only"; for the rest, check "structure and data".
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
