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

[Fawcett - Le Rossignol, Jamie E]

Hi Andrew.

With MS Access you can setup forms to handle the data, but limiting
access would have to be built into the database (MS Access or MySQL).  
I'd add 2 tables.
1 table with a list of access previllages. (ie what they can access and
do)
1 for the user's login details with references to the above table.
You could add the third table, but the above should work as it is.

I know MS Access has issues with multiple users accessing it at the same
time.  (ie data corruption)  And having worked with SQL-Server 2000 I'm
loathed to use Access.

I think that user access to a php/mysql webpage would be easier to
control.

Check sourceforge.net, moodle.org (or other educationally based CMS/LMS)
for possible solutions.

Regards,
Jamie


-----Original Message-----
From: yr7-10it-bounces at edulists.com.au
[mailto:yr7-10it-bounces at edulists.com.au] On Behalf Of WEIR Andrew
Sent: Monday, 23 March 2009 1:09 PM
To: Information Technology Teachers' Offtopic Mailing List;
oz-teachers at rite.ed.qut.edu.au; yr7-10it at edulists.com.au
Cc: link at anu.edu.au
Subject: [Yr7-10it] [Offtopic] Micorsfot access User control

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 

 


_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
Year 7 - 10 IT Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc
 

__________ Information from ESET NOD32 Antivirus, version of virus
signature database 3805 (20090127) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 
 

__________ Information from ESET NOD32 Antivirus, version of virus
signature database 3805 (20090127) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.