protect query

  • Thread starter Thread starter Pammy
  • Start date Start date
P

Pammy

Is there a way to protect a query where it cannot be changed or deleted?
Someone deleted a query we use all the time and it is a very complex query.
Thanks
 
I don't think so. Think about user security, passwords to stop people from
meddling.
 
Pammy

How is it that your users have access (no pun) to the underlying "guts" of
your application? Unless they are trained professionals, what business need
is being solved by allowing users the ability to see the objects in an .mdb
file?

One way to slow down users is to "hide" objects you don't want them to see.
Better still, as implied above, don't let them see ANYTHING but the forms
you've created for them to use.

Sorry, you hit one of my hot buttons... Word and Excel expect users to see
all the commands. MS Access is like a power saw ... folks can cause
themselves (and your application) some serious harm by messing with things
they don't know how to safely use.

If you haven't been doing so already, start making backups!

Good luck

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Create a swichboard and give access to only forms and reports. You can hide
database container itself by changing the options in startup.

Rgds
 
Back
Top