View Single Post
  #2 (permalink)  
Old November 27th, 2006, 07:22 AM
leehambly leehambly is offline
Friend of Wrox
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly


Anything is possible... but unless I missed a meeting, you will have to build this yourself.

I would suggest building a User Table (for your user details), User Trail Table (to store the user actions you want to record) and also a set of forms and a module to administrate the whole thing.

For the User Trail: you are best off using a function to add new trail events. Use the function whenever you come across an event you want to add to the trail. There are no triggers in Access, so you have to build them yourself, essentially.

Frankly, user security and the like are doable in so many different ways in Access, I would suggest a book on the subject.

NB: I DON'T suggest using the Access security features in any way, shape or form.
Reply With Quote