Security features

P

Pietro

Hi,

How can i prevent users from importing my forms?
I need to create a password as well to prevent users from seeing the VB
codes i'm using.
 
J

John Spencer

If you give the users an mde version, they cannot do either.

They cannot import forms, reports, macros, or modules.
They cannot open forms or reports in design view.
They cannot open the VBA and view it.

They can import queries and tables (and possibly menus and import/export
specifications).

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
R

Rick Brandt

Pietro said:
Hi,

How can i prevent users from importing my forms?
I need to create a password as well to prevent users from seeing the
VB codes i'm using.
Click to expand...

Distribute an MDE instead of an MDB.
 
P

Pietro

Thank you John for your reply,
Can i know how to transfer my database from MDB to MDE ?
 
J

John Spencer

To get started"

Open the database up in design view
Select TOOLS: Database Utilities: Make MDE File

Check help on "About MDE Files" for further information.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Top