Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Question about Audit Trail by Allen Browne

Discussion in 'Information Technology' started by JimMurray, Jul 28, 2006.

  1. JimMurray

    JimMurray
    Expand Collapse
    Guest

    I have a SQL backend to my Access 2002 database. Is there something I should
    change in setting up the Audit Trail? The temp table works on the Access
    side, but I'm not transferring the data to the Sql table. Perhaps the field
    types on the SQL table do not match the Access fields? Any help would be
    appreciated.
    Jim
     
  2. Loading...

    Similar Threads Forum Date
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016
    Sikhi Questioning Faith Sikh Sikhi Sikhism Mar 3, 2016
    Entering into Sikhism: Questions on Reht Maryada. Blogs Oct 22, 2015
    A question about kes/hair? Blogs Oct 21, 2015

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    SQL Sever has triggers. Would it not be easier just to set up triggers on
    the tables to write the audit trail?

    It also has transaction logging built-in if you want to use that.

    If you are using an ADP, there is a problem with the sequence of events.
    Microsoft's info:
    Order of Form Delete Events Differs in ADPs and MDBs
    at:
    http://support.microsoft.com/kb/234866/en-us

    There could also be a timing problem with inserting new records. Access
    (JET) assigns an AutoNumber as soon as you begin typing into a new record,
    whereas SQL Server assigns the identity at the last moment.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "JimMurray" <JimMurray@discussions.microsoft.com> wrote in message
    news:89AEBBAA-2EE2-42E2-AD53-3006AA9CC2FF@microsoft.com...
    >I have a SQL backend to my Access 2002 database. Is there something I
    >should
    > change in setting up the Audit Trail? The temp table works on the Access
    > side, but I'm not transferring the data to the Sql table. Perhaps the
    > field
    > types on the SQL table do not match the Access fields? Any help would be
    > appreciated.
    > Jim
     
  4. JimMurray

    JimMurray
    Expand Collapse
    Guest

    Thank you for the quick response. I should use the Sql server's abilities,
    however Access is what I know.
    I have found the mistake in the field type of the SQL table. With the change
    the process works wonderfully. Thanks for the Audit Trail, it's great.

    Jim

    "Allen Browne" wrote:

    > SQL Sever has triggers. Would it not be easier just to set up triggers on
    > the tables to write the audit trail?
    >
    > It also has transaction logging built-in if you want to use that.
    >
    > If you are using an ADP, there is a problem with the sequence of events.
    > Microsoft's info:
    > Order of Form Delete Events Differs in ADPs and MDBs
    > at:
    > http://support.microsoft.com/kb/234866/en-us
    >
    > There could also be a timing problem with inserting new records. Access
    > (JET) assigns an AutoNumber as soon as you begin typing into a new record,
    > whereas SQL Server assigns the identity at the last moment.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "JimMurray" <JimMurray@discussions.microsoft.com> wrote in message
    > news:89AEBBAA-2EE2-42E2-AD53-3006AA9CC2FF@microsoft.com...
    > >I have a SQL backend to my Access 2002 database. Is there something I
    > >should
    > > change in setting up the Audit Trail? The temp table works on the Access
    > > side, but I'm not transferring the data to the Sql table. Perhaps the
    > > field
    > > types on the SQL table do not match the Access fields? Any help would be
    > > appreciated.
    > > Jim

    >
    >
    >
     

Share This Page