audit trail

[law]

I'm duing Allen Browne's audit log but now I'm finding i have to have a
PK in the audTmp table. I've tried adding a PK field at which point
the auditing function quits working. Any ideas? Thanks.

[Allen Browne]

Presumably we are talking about this link:
http://allenbrowne.com/AppAudit.html

Why does your temp table need a primary key? If there is an important
reason, you could add the PK as the last field in the temp table, and then
add an extra Number field to the real audit table so that there is somewhere
to write this extra field. Alternatively, you could re-write the SQL
statements so that they call each field by name and ignore the PK of the
temp table.

--
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.

"law" <Ly***********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I'm duing Allen Browne's audit log but now I'm finding i have to have a
PK in the audTmp table. I've tried adding a PK field at which point
the auditing function quits working. Any ideas? Thanks.

[law]

Worked like a charm. We are migrating to SQL and the network man says
SQL hates it when there is no PK in a table. Thank you and thank you
for all the help I've gleaned from your answers on this forum.

[Trevor Best]

law wrote:

Worked like a charm. We are migrating to SQL and the network man says
SQL hates it when there is no PK in a table. Thank you and thank you
for all the help I've gleaned from your answers on this forum.

It's more like Access hates when there's no PK in a SQL table, it will
treat it as read-only. SQL Server itself will tolerate it but the usual
caveat applies about update/delete statements may take out more than you
expected :-)

--
This sig left intentionally blank

[law]

After migrating with SQL tables and inserting PK in audtmp Table and
that same field as a number field in aud table at the end, when trying
to enter info or edit info, the forms freeze, will not even allow you
to close with close button on form unless you press the escape key. I
did a check without the auding program and all works. Any ideas as to
what is causing the auding table to not allow new/edited info? It was
working fine prior to changing to SQL tables. Thanks.

[Trevor Best]

law wrote:

After migrating with SQL tables and inserting PK in audtmp Table and
that same field as a number field in aud table at the end, when trying
to enter info or edit info, the forms freeze, will not even allow you
to close with close button on form unless you press the escape key. I
did a check without the auding program and all works. Any ideas as to
what is causing the auding table to not allow new/edited info? It was
working fine prior to changing to SQL tables. Thanks.

Can you insert records into the audit table by itself from Access?

--
This sig left intentionally blank

[law]

Sure can

[Trevor Best]

law wrote:

Sure can

You may find Access gets its knickers in a twist if you do a BeginTrans
in VBA, the next table you update will be exclusively locked and even
your own session cannot read from it, IOW it locks itself out. This sort
of behavior doesn't occur when using Jet tables. It may be the audit
code is doing something along these lines.

Have a wait around, see if the freeze turns into a "ODBC Call Failed" or
"ODBC Timeout" message after 1 minute.

--
This sig left intentionally blank