Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    Anyone Have Any Unanswered Questions On Sikhi Or God? Sikh Sikhi Sikhism Jan 7, 2017
    Question About Translations Questions and Answers Dec 20, 2016
    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

  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

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page