Setting up Database Security

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

Guest

I have a database that I want certain users be able to access a specific
form, but have limited options within the form like only being able to enter
in records and nothing else. Is there an easy way to do this? I've gone
over the Tools, Security options and can not figure it out to save my
life...........Someone help please.... :)
 
Sandi said:
I have a database that I want certain users be able to access a specific
form, but have limited options within the form like only being able to
enter
in records and nothing else. Is there an easy way to do this? I've gone
over the Tools, Security options and can not figure it out to save my
life...........Someone help please.... :)
Click to expand...

With no security, you can accomplish this by opening the form in design view
and setting the Data Entry property to Yes.

However if you want to set up security, it requires some study/practice to
get it right.

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
 
Back
Top