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

Thank you, guys! I really appreciate it!

Patrick
--
Pat Dools


"Lynn Trapp" wrote:

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: Different Users for Access 2000
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... The database that I am going to create is going to be ... >Lynn Trapp ... >MS Access MVP ...
    (microsoft.public.access.security)
  • Re: Lynn.....
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... "Sam" wrote in message ... > "Lynn Trapp" wrote: ... >> MS Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: use password prompt for editing form
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... >> Lynn Trapp ... >> MS Access MVP ... >>> all data) and sales employees the ...
    (microsoft.public.access.formscoding)
  • Re: User Level Security and Startup
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... >>"Lynn Trapp" wrote: ... >>> appropriate form for each person who logs on. ... >>> MS Access MVP ...
    (microsoft.public.access.security)
  • Re: Backup using ZipDisks
    ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > Workgroup Information File for the secured database. ... > "Lynn Trapp" wrote in message ... >> MS Access MVP ...
    (microsoft.public.access.security)