Securing your Visual Basic Project

I believe that under data base utilities, there is a menu item to create an mde file. I like to structure the project to wind up with 3 files.

1. Data.mdb
2. App.mdb
3. App.mde

Data.mdb is nothing but tables. typically, this will sit on some shared drive in a lan environment

App.mdb contains your VB source code, queries, forms, etc. You link this .mdb to all of the Data.mdb tables.

App.mde is the "Compiled" version of app.mdb. This is what you distribute to the individual uses desktop or put a single copy on the share. No source code is accessible.

The preference is to separate app from data, then just distribute the data.mdb and the app.mde.

If you have both app and data in one mdb and don't want to split it, you can still use the "create mde" item in the "data base utilities" menu to create an mde that doesn't have any code.