restricting access to a table

M

MS Novice

Is there a way to prevent people from accessing a table? I want them to fill
out the form associated with the table, but not the table itself. This is a
personnel table with SSN. I don't want folks to be able to see each others
SSNs. I just want them to be able to fill out the form.

Thanks
 
S

scubadiver

I am not entirely sure what your question is. You can change the start up
options and disable the shift key. This will stop the database from opening
the database window.

Or are you thinking of a password box for every person? Then you can open up
the form which will filter the records for that person only if the password
is correct using something along the lines of:

DoCmd.OpenForm "Queries Edit form", , , "QueryID = " & Me.QLN & ""
DoCmd.Close acForm, "menu", acSaveNo


in the "on click" event.

In fact, that has given me an idea!
 
S

Sprinks

Access, or more precisely, Jet, the database engine behind the scenes, has
workgroup-based security that allows you to assign permissions to specific
users and groups. Litwin, Getz, and Gunderloy's "Access 2002 Enterprise
Developer's Handbook" has a good section on implementing security.

You will also need to set the AllowByPassKey property to False to prohibit
users from accessing the database window directly by holding the Shift key
when the application loads. A Google search will find code showing how to do
this.

All of this will prevent the casually interested from accessing sensitive
data. Understand, however, that Access security will not prevent a
determined hacker with low-level software tools from getting in. If
operating with that possibility is not acceptable, consider a product like
SQL Server or Oracle.

Sprinks
 
Top