Clear out data (3 Viewers)

[Isaac]

I have been working on a database since January. I am about ready to send it to members of my family, but first I want to remove confidential data that I used to test the application.

Of the 450 tables, perhaps only 50 of them have any sensitive information that I would remove. The sensitive data are medical records. There are no social security numbers or credit card numbers, but someone may want to store that information in the future.

Perhaps only one record in a table with a hundred records may have sensitive data.

I would also like to give my family an easy way to clear out their personal data if they ever want to send the database to another family member.

Is there a tool that will do this? The tool needs to only delete selected records in a table. I will add checkbooks to tables for this purpose.

Thanks.

Isn't that what queries are

 

[June7]

The "tool" is a DELETE query with filter criteria.

 

[BlueSpruce]

The "tool" is a DELETE query with filter criteria.

@DakotaRidge, Do all tables contain sensitive data? Unless there's a boolean field for designating a row as having sensitive data, how is the query going to kno which rows to delete? Why not just delete all rows and compress db so whoever gets the app starts with an empty db? Keep in mind that if you don't split the app into front and backend, every time you provide users an update it's going to overwrite all the data they entered.

 

[Gasman]

The "tool" is a DELETE query with filter criteria.

O/P has no filter as yet to identify what is sensitive.