Access Log

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a log (in a new table) of actions performed to a different table, I cant seem to find any help on this subject matter. If anyone has some information to enlighten me on this, please send it my way. Thanks in advance!
 
Drew said:
I am trying to create a log (in a new table) of actions performed to a
Click to expand...
different table, I cant seem to find any help on this subject matter. If
anyone has some information to enlighten me on this, please send it my way.
Thanks in advance!

There are no Triggers in Access mdb databases. You can do it from a form, by
using an Append (insert) query or by using the update method of a recordset,
in code, and writing the data to the second table. This will not record any
actions performed through action queries or other forms, or directly on the
table itself. Check the help files on the keyword "append" for detailed
instructions on creating an append query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top