Protect Queries

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi Folks - Beyond using User-Level Security, what is the best way to prevent
modifications to query objects. The user base is not that familiar with
Access, so I'm hoping there are some workaround techniques short of ULS.
Thanks.

Michael
 
I find that the threat of applying a baseball bat to users sometimes works.....

A MDE file doesn't stop people from messing with tables or queries. But you
could put all the queries in code and use execute sql statements. Then create
an MDE file to lock them up.

If you don't want to use an MDE, you could make all the queries hidden or
system objects. Still some users could figure it out.

Another option is to split the database and give each user their own copy of
the front end (FE) with the queries, forms, reports, etc. If they mess with
it, it's their own problem. You could even have a fresh copy of the FE copied
to their PC each time that it starts up.
 
Back
Top