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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <PatDools@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF9D6C9F-D036-426F-BFDE-4C7D5865BDFD@xxxxxxxxxxxxxxxx
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.
--
Pat Dools


"Joan Wild" wrote:

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: Prevent Edit... Delete Record... capability?
    ... Pat Dools ... "Lynn Trapp" wrote: ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Network Security?
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... Get a copy of the Security FAQ (there's a link on ... >>> Lynn Trapp ... >>> MS Access MVP ...
    (microsoft.public.access.security)
  • Re: microsoft.public.access.security FAQ
    ... I started with the Security FAQ from Microsoft. ... Here was the problem: after creating the workgroup ...
    (microsoft.public.access.security)
  • Re: Whats missing?
    ... Thanks, Joan, I was rereading the security faq when I received your reply. ... database object from the group "Users". ... secure a database without using the security wizard, ...
    (microsoft.public.access.security)
  • Re: RWOP queries for back-end secuirty: easy/hard? slow/fast?
    ... I've searched for "security faq" in the Access 2003 knowledge base, ... limited to forms, reports, macros, and modules, but that is all that ... ability to restrict database creation that you've been so kind to shed ...
    (microsoft.public.access.security)