backend security in access 2007

[roh_8_it_3]

Hello All,

I have an adp application talking to sql server 2000 hosted on a windows server.We have not allowed the end users to see the database objects.For this , we usually disable the options like -use database window,use access special keys ,allow built in tools/menus from the Tools -Startup option.
This works well with the access 2000 or access 2003 version.

I just installed the access 2007 and suprised that even if we have these options disabled then the end users and turn these on.An user can click on the "More commands" from the drop down next to the Office Button and then check the boxes - Allow Navigation pane,allow built in tools/menus or use access special keys.This gives the end user to access the database.

How can I make sure that no user can access the backend.

Thanks in advance.

 

[MagicMan]

Well there are a lot of posts concerning this. I am sure you will probably read most.
Just a point not really covered in those posts, is the Access Hotkeys. I have removed these from all my forms by using the Forms Property ... Keys as Yes and the KeyPressed Event in every Form/Subform to disable all single/multiple hotkey combo's.

I have posted a couple documents as attachments as well. If you want the vPPC toolkit let me know.

 

[roh_8_it_3]

Thanks for your reply.I tried to search posts on this topic but didnt find any usefull info.
Could you please point me to right direction?

 

[MagicMan]

I just editted the original post and added a couple pdf attachments.

 

[MagicMan]

Basically, the downloadable Developer's Toolkit from Microsoft will create a MDE where the users do not have access to the code. And removing the CTLR+SHIFT at boot, and the hotkeys gives you a relatively safe FE. To take that further, the vPPC Toolkit secures the FE to a degree where most will not find it worthwhile to break.
Most recent vPPC toolkit is available here... http://www.pdtl.co.uk/Access2007/vPPCSecurityToolkit.zip

 

[roh_8_it_3]

here is the another post where i posted what helped me to solve this issue.Thanks for your help.

http://www.access-programmers.co.uk/forums/showthread.php?p=754053#post754053