Thread: Recording and playback keys

John there's a range of legal and moral questions in regard to creating a
key-logger program and installing it on computers. I'm not sure you'll get
that kind of help here. But you probably knew that.

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

This is an odd request. The control knows and records what characters were
typed into it. And you can set the value of a control just by assigning a
character string or numeric value to it. What exactly are you trying to
accomplish here? It sure does sound like an attempt at a key logger. If
you're trying to set up an audit record of some sort, you wouldn't normally
do it by recording individual keystrokes.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Allen, if I need a key-logger, there are plenty out there.

Its really for real time backup of some important fields. Some fields lost
important information during the day i.e. between the two nightly backups
and client do not wish this repeated so I am wondering if some sort of
real-time backup that gets deleted every day once nightly backup is done
would do.

Thanks

Regards

Hi Dirk

I am really trying to do a real-time backup of sensitive and very important
fields. For space saving reasons instead of saving the whole field on update
it seems better to record keystrokes and play them back (to the point we
need) when field restoration is required.

Thanks

Regards

In that case, I would suggest you use the BeforeUpdate event procedure of
the form to record exactly what each field was at the time the entry was
saved. This saves not only new entries and edits of existing entries, but
also a copy of any record that gets deleted.

Here's how to use the form's events to do that:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

Of course, you will want your audit table in another database to meet your
design goal of keeping it separate from the actual data.

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