Results 1 to 2 of 2

Thread: Tracking users

  1. #1
    Join Date
    Jul 2002

    Question Unanswered: Tracking users

    i have a problem on tracking users .
    4 users doing insert, update and delete operations on one table. how can i know (or track) which user did that perticular operation (may be insert, update...).

    or how can i write a trigger on a table level. (if some body can touch my table , some message will be fire...).

    this is very urgent for me. i am waiting for reply.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Access does not support table triggers.

    You can however use the AfterInsert, AfterUpdate and AfterDelConfirm (check if the delete was aborted or actually committed) events of a form. You can create a basic data sheet form to make it look like a normal table. If your users have direct access to the tables I think it's not possible to do what you want with Access.
    Last edited by Apel; 07-18-02 at 05:36.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts