Running Log

  • Thread starter Thread starter Brig
  • Start date Start date
B

Brig

Using Access 2002 and working in a workgroup environment, we would like to
have a running log of changes on a certain record on a text file or memo.

I will attach an afterupdate event to each control that I want to track but
I do not know when to start selecting the file.txt and appending the changes
on it.

For example, one changes the name, I will have a log on:
1. Who (Based on CurrentUser())
2. When (Now())
3. What have been changed to.

The log should look like this:

(Constant are in quotes)
"Date:" 6/11/04 "NameChange:" NewNameofPerson "User:" Brigham

We are not looking for something really fancy and we are hoping that this is
simple(gulp...) enough.

Thank you.

Brigham
 
Brig,

First off, Access is a database. Databases are where you store data, logs
are just another form of data. Don't create a text log if you can help it.
Instead, create a Log table in the database, write the records there, then
you can create a report that will export to a text file if you need that
functionality.

The other advantage of this is that opening and writing to a textfile is
time consuming, so you could have lots of pauses in a multi-user
environment. Whereas updates to a small data table are almost instantaneous
and there is very little chance of a multi-user conflict with your log
table.

HTH
Dale
 
Back
Top