 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / September 2004securing access
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.  Signature--Roger Carlson www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: > 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? > 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? 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. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com >> I've secured my Access database by creating an MDE file because it >> contains confidential data. However, I find that anyone can simply [quoted text clipped - 8 lines] > person who knows how to do a Google search will always be able to > hack into an Access file. 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.