How can i Secure my project

[naveen prasad]

Hi all, i have created a small project in access.

3 database tables. 8 forms, 6 queries.

in start up i put the main form to open.

and now i unchecked the display database window option, so in execution the
, forms, queries and tables will not appear.

even i have customized my menu bar , to only 2 fields,,1. FILE, 2. Help all
other i have removed....

but still any body can go inside my project, like

if we right click on form, it can lead to form design view,

if F11 is pressed we can see the Database window..
I have also made to NO, the allow form view, design view.

but no use..

I want to stop right click on the form, and also right click on the menu bar.

how can i do it.

 

[Gina Whipp]

naveen,

DO THIS ON A COPY...

I repeat... DO THIS ON A COPY

Turn the front end into and MDE. I am of course hoping you split your
database! Then ifr you have make any changes you can make then and
redistribute the front end and everyones data is still intact.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi all, i have created a small project in access.

3 database tables. 8 forms, 6 queries.

in start up i put the main form to open.

and now i unchecked the display database window option, so in execution the
, forms, queries and tables will not appear.

even i have customized my menu bar , to only 2 fields,,1. FILE, 2. Help all
other i have removed....

but still any body can go inside my project, like

if we right click on form, it can lead to form design view,

if F11 is pressed we can see the Database window..
I have also made to NO, the allow form view, design view.

but no use..

I want to stop right click on the form, and also right click on the menu
bar.

how can i do it.

 

[Dorian]

You can disable the F11 key and also compile your project to an mde.
You can also set access permissions on the folder where the project resides.
Try googling Access Security.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[naveen prasad]

can you pls give me some more clear info....

i tried to make mde of a copy of project,, but still no use....

 

[Gina Whipp]

naveen,

What version of Access? I want to make sure I give you the correct
instructions...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

can you pls give me some more clear info....

i tried to make mde of a copy of project,, but still no use....