• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

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.
0
hfanan
Asked:
hfanan
  • 4
1 Solution
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now