I have a database that has many users. I want them to be able to only update
the data through the from. I want everything else to be read only. Is there a
way that I can do this. Thanks so much
Well... it depends on your version of Access, how much work you want
to undergo, and how skilled and determined your users are to get
around your barriers. Up through A2003 you can use "Workgroup
Security" to define users and specify rights to each user. See the
Security Whitepaper at
http://support.microsoft.com/kb/207793/en-us.
Print out the document; study it CAREFULLY, and follow its
instructions scrupulously.
If you have 2007, this option isn't available. It's always been
vulnerable to skilled attack ("locks keep out honest people") and
Microsoft decided to remove it from the new version. You can come
close by giving users a .mde or .accde file which opens to your
startup form, has the database window turned off, and controls your
users access to the database, but again someone knowledgable in Access
can get around this.
