[Yr7-10it] [Offtopic] Micorsfot access User control

[WEIR Andrew]

Dear all,
I am wondering if there is a way to implement access control within an
MS Access database.

We are trying to keep track of staff pd hours. 
So a staff member accesses the database and updates how many hours and
what the topic was then submits to a central location.
The pd coordinator can then access the data and print it of.
Staff are only able to access there own records. The pd coordinator can
access all the records.

The school has asked for a access based solution but I am also
relatively sure it can we done Php Mysql, but not fully sure of how. 
Any ideas on either option would be fantastic.

Regards 
Andrew




Andrew Weir

Information Technology Co-ordinator

 

Thomas Carr College

35 Thomas Carr Drive,

Tarneit, VIC 3029

(P) (03) 8734 2526

(F) (03) 9748 4388

(E) andrew.weir at thomascarr.vic.edu.au

 

IMPORTANT! This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Thomas Carr
College does not represent or warrant that the attached files are free
from computer viruses or other defects. The attached files are provided,
and may only be used, on the basis that the user assumes all
responsibility for any loss, damage or consequence resulting directly or
indirectly from the use of the attached files, whether caused by the
negligence of the sender or not. Any representations or opinions
expressed in this email are those of the individual sender, and not
necessarily those of Thomas Carr College.

Please consider the environment before printing this email