Password protect data entry only

[Kendra]

Good morning,

I have a database with two main functions:

1. Data entry
2. Data look up and report creation

I would like to make the database password protected for
data entry, but open access for data look up and report
printing. Does anyone have any ideas of how to give
different parts of the database different levels of
security?

My dataentry form is called "frm_Input_Screen" and the
data table is called "tbl_New_Report_DB" -- I want these
password protected. The data query form is
called "query_form" -- I want this open access.

Thanks for your time and expertise,
Kendra

 

[Joan Wild]

I have a database with two main functions:

1. Data entry
2. Data look up and report creation

I would like to make the database password protected for
data entry, but open access for data look up and report
printing. Does anyone have any ideas of how to give
different parts of the database different levels of
security?

You need to download and study the Security FAQ
http://support.microsoft.com/?id=207793

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

Although the whitepaper is old, it contains information to help you
understand security.

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