Solved

Access program protection

Posted on 1997-09-28
5
225 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now