Password protect data entry only

  • Thread starter Thread starter Kendra
  • Start date Start date
K

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
 
Kendra said:
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?
Click to expand...

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
 
Back
Top