Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2009

    Question Unanswered: How to make a log of entered queries

    Is there any way to make a log for all the queries which come in the database remotely from an application or entered in the query window.

    I am talking about Ms Access 2003/07

    Please tell me a solution ASAP thanx

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    It would help you get a faster response, if you post the question in the correct forum - the MS Access forum... (Access has its own forum, and, it is not a databases server - it is a desktop database application.)

    Also, requesting "a solution ASAP" is considered fairly rude, as, by implication, you consider your issue more important than any other person's issue.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  3. #3
    Join Date
    Aug 2009
    Up Nort' Wi
    A Solution:
    Assign the incoming query to a variable, store variable contents in a query list table.
    I would throw origin and date created in there as well for tracking purposes.

    Good, fast, cheap...Pick 2.

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    I would just say NO. You cannot do ANYTHING if users are creating queries remotely [or not], using the Access query design interface and not your own interface.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Dec 2004
    Madison, WI
    You asked this previously but never answered my question: What specifically do you mean by "for all the queries which come in the database remotely from an application or entered in a query window"? I can't help you if you don't explain this. My guess is that there is a much better solution.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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