Problem with audit trail code

[ondvirg via AccessMonster.com]

I'm trying to use the Allen Browne audit log code in a database and have run
into a problem. The code works great if everything is in the Access DB, but
I'm trying to store the actual audit tables in a SQL db with the interim temp
tables left in the Access DB. When I try to add a record or change a record
the code fails with the following message:

Run-time error '3622':
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL
Server table that has an IDENTITY column.

With my limited skills, I'm not quite sure what this means...any suggestions?
Thanks

 

[ErezM via AccessMonster.com]

hi
without diving too deep into why and where, just do as it tells you:
find all places where "OpenRecordset" is used, and append ,dbSeeChanges (a
comma and the dbSeeChanges argument) at the end, that's an sql odbc
requirement, and it'll solve the problem

Erez.