Hiding Source Code in Access

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.

Sorry, I should have made it clear that I was using Access 2.0

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.

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

Is there a third party utility available. Because I have seen a Access 2.0 database that had the source code encrypted.

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.

Create a run-time application. Use MSarn200.exe

Ozphil
thanks for you help. I have a question, what do you mean by
PIN=app&pwd

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

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.

Could you please grade this pcorreya.

Thanks, I shall try it out and let you know.