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

Tue Mar 31 23:32:25 EST 2009

you can use Access as the back end of a web app solution which gets around the multiuser problem

the visual studio express tools are free (visual web developer express) and powerful enough for this ...

there is inbuilt access control in visual studio - but it doesn't work with access as back end (needs sql server i think) 

however custom password protection is not hard to do and also works well

i wrote something for teachers and students to use along these lines last year - class sign up system - used password protection for some parts of the application ... which worked fine  ..120 kids accessed it every morning on local intranet and it worked fine 

the lead time and developing and setting this up was more substantial than i expected though, so not sure i'd recommend it for a quick solution - your mileage may vary

could advise a bit offlist if interested

rob 

________________________________

From: yr7-10it-bounces at edulists.com.au on behalf of Fawcett - Le Rossignol,Jamie E
Sent: Tue 3/31/2009 10:10 AM
To: Year 7 - 10 Information Technology Teachers' Mailing List
Subject: RE: [Yr7-10it] [Offtopic] Micorsfot access User control

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 <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
Year 7 - 10 IT Mailing List kindly supported by
http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/>  - Victorian Curriculum and Assessment
Authority and
http://www.vitta.org.au <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 <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 <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.

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

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 8392 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/yr7-10it/attachments/20090401/c3c1d7db/attachment.bin