Solved

Access program protection

Posted on 1997-09-28
5
229 Views
Last Modified: 2012-06-22
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
Comment
Question by:hfanan
  • 4
5 Comments
 
LVL 4

Expert Comment

by:ozphil
ID: 1956779
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
 
LVL 4

Expert Comment

by:ozphil
ID: 1956780
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
 
LVL 4

Expert Comment

by:ozphil
ID: 1956781
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
 

Author Comment

by:hfanan
ID: 1956782
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
 
LVL 4

Accepted Solution

by:
ozphil earned 200 total points
ID: 1956783
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question