Restricting Access to certain Forms

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?
 
J

Joan Wild

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Secured Access to Forms 1
Set up User Restrictions 1
Restricting access to records 3
Record level access 3
Access Issue, Macro Single Step, Error 3270 0
A2007:Restrict displaying forms by user group 2
Setup data security in Access 2003 3
Password for users 1

Top