Password protection for database editing 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

 

[Douglas J. Steele]

I think you'll need to look into applying Access security.

Here's the Access Security FAQ:
http://support.microsoft.com/default.aspx?scid=/support/access/content
%2fsecfaq.asp

My advice is to read it carefully several times, try it on a copy of your
database, and make sure you don't leave out any of the steps.

There's a newsgroup devoted specifically to this topic on this server if you
run into problems:
microsoft.public.access.security