Access program protection

How CAN i PROTECT my access source code from being seen or edited by others.
Do not tell me to use the security options. I have used and it can simply be overridden.
hfananAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ozphilCommented:
which version of Access. You can use security options but you have to create a new system.mda (in Access 2, different name in  other versions) and follow some involved procedures.

Or you can create a runtime version of your application with ADT (Access Developers Toolkit).

All my apps use the first method, and my code is completely uncrackable.



0
ozphilCommented:
For access97 you can save as MDE file, which gives you the following security (extracted from help file):
If your database contains Visual Basic code, saving your database as an MDE file compiles all modules, removes all editable source code, and compacts the destination database. Your Visual Basic code will continue to run, but it cannot be viewed or edited, and the size of your database will be reduced due to the removal of the code. Additionally, memory usage is optimized, which will improve performance.
Saving your database as an MDE file prevents the following actions:

·      Viewing, modifying, or creating forms, reports, or modules in Design view.
·      Adding, deleting, or changing references to object libraries or databases.
·      Changing code using the properties or methods of the Microsoft Access or VBA Object models ¾ an MDE file contains no source code.
·      Changing your database's VBA project name using the Options dialog box.
·      Importing or exporting forms, reports, or modules. However, tables, queries, and macros can be imported from or exported to non-MDE databases. Any tables, queries, or macros in an MDE database can be imported into another database, but no forms, reports, or modules can be imported into another database.
0
ozphilCommented:
I have dealt with a question similar to this in Q.8630012788.

The procedures i gave were for Access 2, but the procedures for Access 95 and 97 should be similar. It took many weeks to develop these procedures and have to be followed precisely.

But once done you have uncrackable security.
0
hfananAuthor Commented:
I have tried saving the database with MDE extension. But I could view the design of forms reports and code and even I could update it.
Also creating a system.mda can easily be overridden by erasing the system.mda and using the defualt one
0
ozphilCommented:
I think i confused by presenting you with two methods. I havent even tried using MDE.

The other method provides security you cannot crack.
This is blood, sweat and tears stuff, not available from anywhere except (until now) here.

1. Create the mda FIRST ( a copy of system.mda) with Workgroup Administrator with PIN = app&pwd
Optional: Make MDA swicther icon (utility to be supplied) for convenience
3. Open Access linked to new mda
4. Open MDB to be secured
5. Create <superusers> group, with PIN = app&pwd
6. Create <superuser> user, with PIN = app&pwd
7. Make <superuser> a member of Admins, users and <superusers>
8. Make password for Admin, quit Access, and reenter as <superuser>
9. Create new MDB and import database from admin to <superuser>
10. Grant all rights to <superusers> group
11. Grant user only privileges to users group
12. Remove admins group from Admin User
13. Assign password to currently logged in <superuser>
14. Dont forget to record pins and passwords

where app&pwd is concatenation of appname and a pasword, or any naming you prefer.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.