Setting a Password on Delete Queries?

  • Thread starter Thread starter Steve C
  • Start date Start date
S

Steve C

Is there a way to set a password on a delete query? I have
an application were many users enter data via forms. I
have written a couple Delete queries to clean up the
databases, however I dont want the queries to be available
to all the users.
 
You need to set up User-Level security so your users are required to login
when they open the database. After that, you can set permissions for ALL
objects in your database.

Rick B


Is there a way to set a password on a delete query? I have
an application were many users enter data via forms. I
have written a couple Delete queries to clean up the
databases, however I dont want the queries to be available
to all the users.
 
Depending on the level of security you want, you could
hide the queries and provide yourself a form to run them
from. You could then add a simple password protection in
the form. (in the form of a input box/if statement) This
would stop accidental usage of the queries but would not
stop someone who knew they were there from using them.
Depends on how much trust you have in your users, but it
is a quick way to add some degree of safety.
 
Back
Top