Hi All,

I just finished creating my first all-inclusive MS-Access application. Ideally, I would prefer to prevent mischievous users from accessing everything except the switchboard items. This would include the menu system and except for the "print" shortcut button, all the control buttons. In fact, if I could somehow automate printing reports, I would hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Chuck:

Under Tools/Database Utilities you will find an item that says Make
MDE file.

Assuming it is not greyed out, click on it.
If your db is X.mdb you will get X.mde created.
The mde file will do what your current MDB does, but all design info
is stripped. Your code, properties, etc. can not be seen.

This is just what you want it to do.

If ithe line is greyed out, try going tino design for a module, choose
debug and then compile. It should allow it then. If not check help.

This is the somplest way to do what you want.

Good luck
Ira Solomon

On Sat, 16 Jul 2005 00:10:57 GMT, "Chuck Insight"
<j.gillham (AT) insightbb (DOT) com> wrote:

Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks


"Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote

everything except the switchboard items. This would include the menu system
and except for the "print" shortcut button, all the control buttons. In
fact, if I could somehow automate printing reports, I would hide it, too.
Please reply with any recommendation.

THe mde provices for all of that.
You may need to also goto to both startup and options under tools and
disable toolbars, menus, db window, etc.

On Sun, 17 Jul 2005 19:16:17 GMT, "Chuck Insight"
<j.gillham (AT) insightbb (DOT) com> wrote:

Thanks very much Ira,

I was unaware these options existed, and will try your recommendations
presently.

Chuck

"Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote