Preventing users from making changes directly in table

[Ron]

We constantly have users going directly into the table to make changes
to existing records. How can I keep this from happening and have users
use forms or update queries to make changes to existing records ?

 

[Jeff Boyce]

Ron

A simple approach is to hide the tables, but a somewhat sophisticated user
could circumvent this.

A "strenuous" approach is to apply Access security (and this is still
"breakable").

Have you considered firing anyone who touches the tables directly <g>?

If you already have the pieces in place, consider storing the back-end data
in something with stronger security (e.g., SQL-Server).

 

[Albert D.Kallal]

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

The above should keep users out of the tables...and using a mde will even
further keep people out of stuff....

And, if you are have any application in multi-user mode, then a mde can be
used for the front end.. You can read about multi-user mode here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm