How to secure application ?

[drPavlovic]

I'm almost finished software, and I have to deploy now.
I'm wondering, what is the best way to secure software ?

Is MDE secure enough ?

Or, is it possible, just like in VB , to create "dll" file, and to put code in dll file,
and call it from forms, reports ?

thanks in adv

 

[mhartman]

Hello:

Compiling your project to a MDE would make it secure. Be sure to keep a copy of the original for tweaking purposes if needed.

Regards
Mark

 

[Tezcatlipoca]

It depends on the type of security you want. If you have a database that only a handful of people are only ever going to use at any given time, you could just lock off the aspects of the database itself.

Look at the example I've included. This is a database (you will need Office 2003 to run everything on it properly!) I wrote for my company. Since the maximum amount of users needing it is only 8, I've simply locked everything off to prevent accidental/malicious damage. You'll note that you cannot even use the Shift key during opening trick to get into it.

If you need to access the programming behind it, just go to the View/Edit Form (the top button on the switchboard), and click the little grey box to the right of the 'A' in the title. On the proper form, that box has it's 'Transparency' variable set to 'YES', so it is hidden. In this manner, I can secure the entire database, yet always have a backdoor myself.