Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

see my comment in http://superuser.com/a/545011/194578. 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

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
1  
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 at 23:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.