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?