Setting Access security

[Sid]

I hope somebody could help me with this.

I have a access database which includes some forms, queries and
tables. Once I upload it on to the office network, I was hoping if I
could set up security for the database such that certain users can
only access certain forms based on their designated office dept.

I am not sure how this functionality could be achieved.

Thanks,
Sid

 

[Roger Carlson]

Your first stop is to read this link:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
very carefully and read it multiple time. When you have questions, bring
them up in the Access Security newsgroup.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L