Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50

    Unanswered: How can I "log" when a user loads a Data Access Page?

    Hello

    I have a sql server 2000 database, accessed via some data access pages developed using Access 2000. I would like to be able to "log" which user and when loaded the said pages, that is to be able to perform a triger-like action such as:

    Insert into logtable (Page_accessed, User, time)
    select 'Mypagename', current_user, getdate()

    What changes should I make to my data access page?

    THX

    Marp

  2. #2
    Join Date
    Jan 2004
    Location
    Norwich UK
    Posts
    20
    The below thread may be of some help:

    http://www.dbforums.com/showthread.php?threadid=976376

Posting Permissions

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