Restricting Access to certain Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I set up user ids for all users of a database, can I allow one user full
access to everything but restrict others so that they can use certain forms
to update data but not get into other forms or the reports. If so how?
I suspect the answer is no so I guess the solution may be to split up the
database so only the forms the restricted users need to use are in one
database with the required tables linked and everything else in another then
set the restrictions at database level. Can anyone confirm or otherwise?
 
kbrad said:
If I set up user ids for all users of a database, can I allow one
user full access to everything but restrict others so that they can
use certain forms to update data but not get into other forms or the
reports. If so how?
Click to expand...

Yes, you can. Download and study the security FAQ available at
http://support.microsoft.com/?id=207793

Be sure to follow every step outlined or your database won't be secure.
 
Back
Top