Transaction Log?

[steve avis]

i have been told that a transaction log should be implemented into a
Facilities Management Database that i have created, could anyone possibly
tell me why and how to achieve this. This information will aid in the
succesfull completion of my class one GPS project.

your assistance in this matter would be greatly appriciated.

Thankyou steve.

 

[Arvin Meyer]

Transaction logs are built in to most server based database engines (like
SQL-Server) but not in desktop databases. To implement one, you'll need to
write the data using Transactions. I'd try naming the Transactions as
functions and building a log which gets its data from a few lines of code in
the function. Something like:

Open "C:\Transaction.log" For Append As #1

Print #1, Format(Now, "mm/dd/yyyy, hh:nn:ss") & " - " &
"TransactionName"

Close #1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Allen Browne]

If you are wanting to record details of all inserts, edits, and deletions,
see:
Audit Trail - Log changes at the record level
at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html