Update Query!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices
 
Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices
Click to expand...

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
Click to expand...

There's an easier way!

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".
 
Back
Top