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

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.


--
Joan Wild
Microsoft Access MVP

Pat Dools wrote:
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.
--
Pat Dools


.

Relevant Pages

  • Re: Lock / Unlock VBA project
    ... "Alex Dybenko" wrote: ... make MDE? ... library MDB - create ne mdb, import forms/modules from your app, which ... have to make MDE of it and add reference to library MDE in order to make MDE ...
    (microsoft.public.access.modulesdaovba)
  • Re: Converting Access 97 MDE to Access 2003
    ... what is the MDB front-end you are ... The mdb front end is of course the original mdb you had to make the mde. ... ms-access is the in the SAME VERSION as what you are developing under. ... a mde file is created by going tools->database utile. ...
    (microsoft.public.access.conversion)
  • Possible Fix for "Unable to create MDE" Error and "Unexpected Error 40230" in Access 2002
    ... compile it and create an MDE on the local disk. ... With each one I progressively deleted more and more objects in the mdb until ... Dev PC is WinXP SP1. ...
    (microsoft.public.access.conversion)
  • Re: 5 access 2000 users and 1 AccessXP user
    ... > Making the user an administrator on the local machine worked for the case ... > it to th PC (it is an mde file). ... The back end is on a server running win2K ... locate the front end mdb file on the ...
    (microsoft.public.access.conversion)
  • RE: Best way to protect a shared MSAccess database...
    ... Besides the .mdb file permissions itself, ... puts all of the data into one .mdb and all of the forms, reports, querys, etc ... Database Utilities to compact current.mdb (this reclaims the file space ... Startup and uncheck the Allow Full Menus option. ...
    (microsoft.public.windows.server.sbs)