Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have tables in an Access DB (Office 2007) which have confidential/sensitive data which needs to be removed. The remainder of the database need to remain functional.

How do I securely remove/shred the classified data? Does MS-Access store data outside of the .mdb file?

share|improve this question
what type of information are you trying to delete? records? fields? keys? – Raystafarian Feb 16 '12 at 15:36

Access doesn't store any data outside the tables unless you program it to do so.

You can delete the fields from the table or just the data. Keep in mind, any forms, reports or queries containing those fields will likely cause errors unless you also modify them. So, it might be a better choice to just delete the data.

Be warned, once you delete data from tables, it is gone.

share|improve this answer
Good advice. I suppose you should you shrink the database after deletion to minimize the chance of any data being left in "unused" space. – Nifle Feb 16 '12 at 19:42
Or wipe the data from the tables, make a backup from all programs and data, secure erase the drive and copy the backup back. – Hennes Oct 31 '14 at 23:21

see my comment in By the way: if you use linked tables or linked files, you data will be stored outside the mdb or accdb.

share|improve this answer
Please include the comment in the answer. Links can change or go down, which would invalidate your answer. – bwDraco Oct 2 '15 at 19:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .