Question about Audit Trail by Allen Browne

[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

 

[Allen Browne]

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.

 

[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