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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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
 
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.
 
Back
Top