Code for a table?

[iamnu]

I have a Yes/No field named DV, in my table. It's default value is
True. If someone where to open the table and change any value, I'd
like set the DV field to False.

Can this be done?

 

[Arvin Meyer [MVP]]

There are no triggers in Access, which essentially means that all code must
be run from forms and reports, or in some case from a query. If you are
concerned about someone changing the table, you'll need to use User-Level
Security, which is only available with the MDB format. Essentially, users
have no permissions on the tables, and only get access through queries with
the WITH OWNERACCESSOPTION.

If you'd like to read more about User-Level Security, here's some sources:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

 

[iamnu]

There are no triggers in Access, which essentially means that all code must
be run from forms and reports, or in some case from a query. If you are
concerned about someone changing the table, you'll need to use User-Level
Security, which is only available with the MDB format. Essentially, users
have no permissions on the tables, and only get access through queries with
the WITH OWNERACCESSOPTION.

If you'd like to read more about User-Level Security, here's some sources:

Security FAQhttp://support.microsoft.com/download/support/mslfiles/SECFAQ..EXE

Lynn Trapp's summarization:http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:http://support.microsoft.com/defaul...upport.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:http://www.jmwild.com/security02.ht...NoLogin.htmhttp://www.jmwild.com/Unsecure.htm

Thank you, sir!