Security features

[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.

 

[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

 

[Rick Brandt]

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.

Distribute an MDE instead of an MDB.

 

[Pietro]

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

 

[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