Password on Database

  • Thread starter Thread starter No Go
  • Start date Start date
N

No Go

How can I protect the database from others accessing the data in tables. I
would like them to only have access to reports and forms....
Cheers
John
 
No Go said:
How can I protect the database from others accessing the data in tables. I
would like them to only have access to reports and forms....
Click to expand...

Access' user and group level security allows specific security on objects,
but I think for the reports and forms to show the data, the user will at
least have to have access to queries against the tables. Get the Security
FAQ from the Microsoft Website,
http://support.microsoft.com/default.aspx?scid=kb;en-us;165009 and/or
http://support.microsoft.com/default.aspx?scid=kb;en-us;207793.

It is not trivial, so study it carefully.

Larry Linson
Microsoft Access MVP
 
Back
Top