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.

Does Access store tables and data outside of the *.mdb file ?

I have a computer which currently has a large working database on it containing some tables with confidential data. I would like to securley delete/remove the confidential data. Does all the data live in the *.mdb file?

share|improve this question

migrated from serverfault.com Feb 16 '12 at 16:21

This question came from our site for professional system and network administrators.

    
Don't forget to mark an answer for your questions. –  mfinni Mar 2 '12 at 20:29
add comment

3 Answers

up vote 4 down vote accepted

Yes, all the data is in the MDB file, unless you're using ODBC or otherwise linking tables to other data sources, perhaps other MDBs.

share|improve this answer
add comment

Deleting data and compressing the database does not guarantee that all the confidential data will be completely removed. You should use an anonymizer to obfuscate all confidential data - and all your forms and queries will continue to work properly. Here's an anonymizer that you get get for free: http://www.access-experts.ch/werkzeuge_produkte/daten-anonymisierung/index.html

Good luck Rainer

share|improve this answer
add comment

I would say do this:

  • Make a copy of the Access database.
  • Then run a delete query.

This way you will always have a backup.

share|improve this answer
add comment

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.