Password on Database

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
 
L

Larry Linson

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
 

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

Access Access Report Works on One Machine but not Another 3
Retrieve data from Access database and fill data in form 0
Record-Locking remains open after closing 0
Access Microsoft Access 2003 0
Access Need help in making asset history in my current database. 1
Query design 0
Copy and move Access 13 database on laptop to pc with Access 13 0
How to Print a Subreport from a filtered search 1

Top