Prevent 'Edit... Delete Record...' capability?

[Pat Dools]

Hello,

I have gone into the 'Startup...' menu and de-selected showing the Database
window, 'Allow Full Menus', 'Allow Default Shortcut Menus', and 'Allow
Built-in Toolbars', but users, while entry data into a form, can still go to
the 'Edit..' menu and select 'Delete Record'. I do not want them to be able
to do this. How can I disable this capability?

Thanks.

 

[Joan Wild]

You could always set the Allow Deletions property of the form to No.

Then make a MDE from your MDB and give that to the users (be sure to keep a
copy of the MDB in case you need to make more changes).

Other than that, you should also consider creating your own custom
menus/toolbars that don't include commands you don't want them to have.

 

[Pat Dools]

Great, thank you, Joan. Do you happen to have a URL or white paper that has
like an 'FAQ' for security questions for Access 2002-2003? That would be a
great thing to have.

Thanks again.

 

[Lynn Trapp]

You can find a link to the Security FAQ at
http://www.jmwild.com/Accesssecurity.htm or on the Security page of my
website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Pat Dools]

Thank you, guys! I really appreciate it!

Patrick

 

[Li Qiu]

Hi Joan,

I set the "Allow Deletions" property of the form to No and made a MDE file.
In the Tool -> Startup, all checkboxes are unchecked. However, the edit ->
delete record in microsoft window menu still can delete the record in the
form. My system is Access 2002 run on window XP professional.
Would you please help me out.

Thanks a lot.
Li Qiu

 

[Joan Wild]

I cannot reproduce this. If you set the Allow deletions to 'no', then the
Edit - delete record menu item is disabled here. Tested in 2002 on WinXP.