I'm Ready for Security

[RobUCSD]

I've been working on a comprehensive Access data base for managing patients
in sub specialty of cardiology.

I'm ready to take on security as my next big issue. I have implemented
user-based security with the security wizard and encrypted the back end db. I
need help with, or reference to, the following issues:

1) Audit Trails
2) Auto log off (5 min intervals)
3) Version Control (not exactly security)

Any advice or resources are greatly appreciated. I am a novice at
implementing these things through code.

Thanks,

Robert

3)

 

[Douglas J. Steele]

For Audit Trails, see what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html

For Auto Logoff, see http://support.microsoft.com/kb/210297 (don't worry if
you're using a different version than Access 2000: it's the same for all
versions)

For Version Control, what exactly are you trying to achieve?

 

[RobUCSD]

Thanks Doug for the point in the right direction. With respect to version
control, when my users login I want the client app version Id (i.e., v1.1)
checked against the latest version available on the server. If the client
version is older than the most recent version then I want to put up a msg
like, "Please wait while your application is being updated" and then set up
an install routine to do this with little or no user input.

Hope that's clear.

Thanks, Robert

 

[Douglas J. Steele]

See the free Auto FE Update Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm