Hiding Source Code in Access

Is there a way to hide your source code in access ie the module file so that the .MDB file can be distributed or is there any utility that will encrypt your source code so that is not readable.
LVL 1
pcorreyaAsked:
Who is Participating?
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.

baskomurcuCommented:
If you are using Access97 you may convert your MDB files into MDE files. This conversion compiles all modules, removes all editable source code, and compacts the destination database.
Be sure to save a copy of your original database (in MDB format). If you need to modify the design of forms, reports, or modules in your database, you must open the original database, modify it, and then save it as an MDE file again.

Ali Baskomurcu.
0
pcorreyaAuthor Commented:
Sorry, I should have made it clear that I was using Access 2.0
0
baskomurcuCommented:
As far as I know this is not possible in Access version 2.0. You can only encrypt a database, which compacts the database file and makes it indecipherable by a utility program or word processor.

Ali Baskomurcu.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

peter_vcCommented:
Isn't there some sort of compiler for Access 2.0 in the Access Developers TookKit?  I'll look into this.

0
pcorreyaAuthor Commented:
Is there a third party utility available. Because I have seen a Access 2.0 database that had the source code encrypted.
0
ozphilCommented:
Providing security in Access 2 is an art form which is very poorly documented.

I developed a 13 point method  to do this, it works everytime and nonone can look at or modify my Access code, form and report design and code, macro code, query design.

By following the procedure I have documented step by step you can achieve the source code encryption that you find in commercial Access2 packages.

The procedure is in the very difficult class and is worth 200 points.




0
kjkapasCommented:
Create a run-time application. Use MSarn200.exe
0
ozphilCommented:
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
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
pcorreyaAuthor Commented:
Ozphil
thanks for you help. I have a question, what do you mean by
PIN=app&pwd
0
ozphilCommented:
make up a PIN password that you can remember, such as application and your favorite password.
ie app&pwd, where & means concatenation. Or just a password would do. Its just personal preference

0
ozphilCommented:
In my answer i mentioned an MDA switcher utility.

This makes switching between protected MDBs a breeze.

It is chg_mda.exe, from Integrated Office Solutions Inc.


0
ozphilCommented:
Could you please grade this pcorreya.
0
pcorreyaAuthor Commented:
Thanks, I shall try it out and let you know.
0
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.

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.