[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access program protection

Posted on 1997-09-28
5
Medium Priority
?
239 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 400 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

873 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