im still battleing my user base, many of whom have a mania for leaving machines logged on exposing my databases to all and sundry.
the IT dept have refused to create a new group in their group policy that will logout or lock the users who do this and my boss has refused my request to deny the repeat offenders access to my db's.
time to get tough.
i want to try and program a vb executable or embed vb into my applications (access mde's/ade's with an sql backend) which will detect if there has been no activity for a certain period and then deny them access to any of the apps i decide.
the db is for the school i work at and as part of the DPA we can't have all the contact, pastoral or academic info accesible by anyone and the only way i can stop this it seems is by using code that will detect periods of inactivity and then restrict access to that data.
and before any anyone ask no i can't simply ask the users to lock their machines they don't listen!!!
im waiting for an old question to be refunded so will up the points for this when it does.