lock fields in DB with the content of other fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

handex - 03 Feb 2006 21:09 GMT

Hi I am making a database, to guide students through an project start,
the ideer is to make a total project description in the DB.

The students should not be able to see each others description in the
forms

The content of the fields should be locked when approved

How do i program these aspects in the database

Best regards
Steen Heide

Reply to this Message

Larry Linson - 05 Feb 2006 03:26 GMT

This can be done by invoking Access' security and giving the students only
Read With Owner's Permission Query access to the data via Forms and Reports.
Visit http://support.microsoft.com and search Access 2000 for the Security
FAQ. Download and study it -- it's not for the 'faint of heart'.

Larry Linson

> Hi I am making a database, to guide students through an project start,
> the ideer is to make a total project description in the DB.
[quoted text clipped - 8 lines]
> Best regards
> Steen Heide

Reply to this Message