S
Sarah
I have been trying to implement Allen Browne's Audit Log
(allenbrowne.com/AppAudit.html) but am having some trouble. A little
bit about the database setup first...
Tables:
IDs (1 autonumber ID field and 3 fields to identify a unique form type)
RWAs (ID_Num field to link to IDs table, no duplicates, a dozen or so
other fields)
RFQs (ID_Num field to link to IDs table, no duplicates, a dozen or so
other fields)
Accounting (ID_Num field to link to IDs table, duplicates possible, 3
other fields)
Forms:
RWAs_New
RWAs_Update
repeat for other tables
To work with the audit log, I created a new autonumber field Update_ID
in all tables except IDs since it already had an autonumber field. I
set the Update_ID field to be the primary key in all tables.
When I use the RWAs_New (or RFQs_New) form to enter a new record, I
audit the IDs table because I really just want to know who created the
record. This works fine.
When I try to update information, I get the following error:
An unexpected situation arose in your program.
Please write down the following details:
Calling PRoc: Auditor.AuditEditBegin()
Error Number 3131
Syntax error in FROM clause.
Unable to record because Error 3265
Item not found in this collection.
I click OK and get the same error for Auditor.AuditEditEnd().
I've double checked my typing and made sure all the tables and field
names have no spaces. In addition, the errors aren't being recorded in
the error log table. Although I'm much less concerned about that.
Any thoughts or suggestions would be much appreciated.
-Sarah
(allenbrowne.com/AppAudit.html) but am having some trouble. A little
bit about the database setup first...
Tables:
IDs (1 autonumber ID field and 3 fields to identify a unique form type)
RWAs (ID_Num field to link to IDs table, no duplicates, a dozen or so
other fields)
RFQs (ID_Num field to link to IDs table, no duplicates, a dozen or so
other fields)
Accounting (ID_Num field to link to IDs table, duplicates possible, 3
other fields)
Forms:
RWAs_New
RWAs_Update
repeat for other tables
To work with the audit log, I created a new autonumber field Update_ID
in all tables except IDs since it already had an autonumber field. I
set the Update_ID field to be the primary key in all tables.
When I use the RWAs_New (or RFQs_New) form to enter a new record, I
audit the IDs table because I really just want to know who created the
record. This works fine.
When I try to update information, I get the following error:
An unexpected situation arose in your program.
Please write down the following details:
Calling PRoc: Auditor.AuditEditBegin()
Error Number 3131
Syntax error in FROM clause.
Unable to record because Error 3265
Item not found in this collection.
I click OK and get the same error for Auditor.AuditEditEnd().
I've double checked my typing and made sure all the tables and field
names have no spaces. In addition, the errors aren't being recorded in
the error log table. Although I'm much less concerned about that.
Any thoughts or suggestions would be much appreciated.
-Sarah