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

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 Feb 16 '12 at 16:21

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

Don't forget to mark an answer for your questions. – mfinni Mar 2 '12 at 20:29
up vote 5 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

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:

Good luck Rainer

share|improve this answer

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

You must log in to answer this question.

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