>I think that MS Access can be very secure with MDE and password protected MDB
>file. It all depends on how you create your DB. The way I secure my Access
>DB is split FE and BE with MDB and/or SQL. On the FE, I only include forms
>with VBA codes and modules. On the BE, I only include tables and reports.
Just curious. Why not put the reports in the FE?
>I use ADO to communicate between the FE and BE. On the BE with the MDB file, I
>setup the password with 20 + characters (including special characters so it
>will be very hard for anyone to crack).
I think here are crackers out there for Access security.
Note that I'd suggest breaking up the password and storing chunks of
the password in different non contiguous variables, that is mix them
up, so someone going through the hex in the FE MDE can't see the
phrase.
Const Part2 as string = "def'
Const Part4 as stirng = "jkl"
Const Part3 as string = "ghi"
Const Part1 as string = "abc"
>I have not heard anybody crack a module in a MDE file (or I could be wrong).
MDE to MDB Conversion Service for Microsoft® Access
http://www.everythingaccess.com/mdeconversion.htm
Converting a Microsoft Access MDE file back into an MDB file. Section
2 at http://www.access.qbuilt.com/html/faq.html
Tony

Signature
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
NLD - 28 Aug 2007 20:08 GMT
Tony,
I appreciated you pointed me to the "Everythingaccess" site. I guess the MDE
file is that secure after all. If anyone could crack a module in a MDE file,
then he/she could see a MDB's password. As far as I know, what I described
on my previous post was as secure as I can get on Access.
>Just curious. Why not put the reports in the FE?
I don't put reports in the FE because it has no tables/queries there and
reports won't work with ADO, so that is why I put reports/tables/queries on
the BE.
Also, you suggest that I should break down a password into different pieces
but if they (like "EverythingAccess' people") could crack it then it won't be
that helpful. They can see all VBA codes except comments.
NLD
>>I think that MS Access can be very secure with MDE and password protected MDB
>>file. It all depends on how you create your DB. The way I secure my Access
[quoted text clipped - 28 lines]
>
>Tony