password a field in access 2003?

M

Mostly

Is there a way to password a field in access 2003? I have a user that wants
to be able to be the only one to enter date in a field I have called closed
project.
 
J

Jerry Whittle

Not really. Newer versions of Oracle do allow protecting by fields. Don't
know about SQL server.

You could join two tables in a 1-to-1 relationship and put the sensitive
data into the second table. You would still need to implement user level
security to allow your one user to see data in that particular table.
 
G

George Nicholson

using something like:
http://mvps.org/access/api/api0008.htm (Get User Login Name)
you can easily get the current user's windows login (assuming everyone has
there own).

Then, in the Form_Open event, you could disable/enable the field/control
depending on the user login.

This assumes that you've set things up so that users can only modify data
via forms and that they can't open tables directly. If they can, look into
UserLevel security.

This also wouldn't prevent anyone from executing ADO/DAO/SQL code in another
app (say Excel) that would update that file-table-field, but it might be
sufficient for your purposes.

HTH,
 
Top