securing access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've secured my Access database by creating an MDE file because it contains
confidential data. However, I find that anyone can simply use Microsoft
Access to link to or import the tables in that MDE. How do I stop my MDE
from sharing it's data to any application that requests it?
 
An MDE is NOT security. All an MDE does is remove the source code from your
forms, reports, macros, and modules so that no user can modify these
objects. It does not affect tables and queries.

The only way to restrict access in the way that you want is to implement
Access Security. Explaining that is beyond the scope of a newsgroup post,
but Microsoft has produced a Security FAQ which has all the information you
need to do it. You can find it on the Microsoft site or you can also
download it from my website:
http://www.rogersaccesslibrary.com/knowledge.html. It is the link at the
top of the page.

Read the document carefully several times BEFORE doing anything and then
work on a COPY of your application.

--
--Roger Carlson
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
I've secured my Access database by creating an MDE file because it contains
confidential data. However, I find that anyone can simply use Microsoft
Access to link to or import the tables in that MDE. How do I stop my MDE
from sharing it's data to any application that requests it?
Click to expand...

The only "protection" provided by an MDE is your code. It has nothing to
do with data. You would have to use the User-Level security features in
Access to protest the data. Mind you that is mostly protection from the
uninformed and/or the lazy. A determined person who knows how to do a
Google search will always be able to hack into an Access file.
 
Rick said:
The only "protection" provided by an MDE is your code. It has
nothing to do with data. You would have to use the User-Level
security features in Access to protest the data. Mind you that is
mostly protection from the uninformed and/or the lazy. A determined
person who knows how to do a Google search will always be able to
hack into an Access file.
Click to expand...

Thanks for telling him that. (really).

You didn't need to say "determined." You can lazily download from
http://www.lostpassword.com/access.htm#order a $45 program that will let you
drag-n-drop an Access .mdb or .mdw file onto a panel and it will tell you
every user name, user group, user password and database password.

Access "security" is a joke. If your data is sensitive, host it elsewhere.
 
Back
Top