By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

securing access

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/...UBED1=ACCESS-L

<arch> wrote in message news:41********@funnel.arach.net.au...
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?

Nov 13 '05 #2

P: n/a
<arch> wrote in message news:41********@funnel.arach.net.au...
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.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

P: n/a
DFS
Rick Brandt wrote:
<arch> wrote in message news:41********@funnel.arach.net.au...
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.


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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.