Securing a Database

[JoeGriffin]

I am trying to secure a database I have created. What I have done is to
install the ByPASSKEY Key module and then create an MDE file. This
works perfectly and I cannot get access to the database. Does anyone
know of any ways in which someone can get to the code in my database
after I have done the above ??

 

[Brendan Reynolds \(MVP\)]

No. But of course, if I did, I would hardly post that information in a
newsgroup.

When you create an MDE, the text of the source code is removed, only the
compiled version of the code remains. So in order to read your code, a
hacker would not only have to extract the compiled code from the MDE, but
convert the compiled code back into readable text format. While it is
theoretically possible for someone to write a program to do that, there are,
to the best of my knowledge, no reports of anyone having actually done so.
After all, anyone capable of writing such a program would be perfectly
capable of reproducing the functionality of your VBA code, so where is the
incentive for such a person to write a decompiler?

Any security can be broken, given sufficient skill, time, and resources. But
the resources that would be required to decompile the code from an MDE are
likely to far exceed the value of the code.