Help - Log Transaction

[Evelyn Pabón]

Hi

I created a database application for the company I'm working and as part of
the CFR Part 11 it is a requirement for al the application that are for
manufacturing us to have some security option like employee account to log
on in the database and a transaction log to register al the activities that
has occurred and saved with the employees name who made the transaction or
the changes.

But I don't have an idea on how to create this transaction log file. Could
someone give me a hand on this? I would really appreciate any help.

Thanks,
Evelyn

[Tony Toews]

"Evelyn Pabón" <ep****@coqui.net> wrote:

I created a database application for the company I'm working and as part of
the CFR Part 11 it is a requirement for al the application that are for
manufacturing us to have some security option like employee account to log
on in the database and a transaction log to register al the activities that
has occurred and saved with the employees name who made the transaction or
the changes.

There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default...;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://users.bigpond.net.au/abrowne1/AppAudit.html
The article addresses edits, inserts, and deletes for a form and subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that track the changes
made to fields in one or more tables.

However one problem is that with Access anyone can get at the tables and muck with
them directly. For true security you'd have to go to SQL Server as a backend.

Why did you cross post to the VB newsgroups as well? Are you working in Access or
VB?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Larry Linson]

You will have to create these yourself, by limiting the users to accessing
the data via your forms (and not allowing them direct access to tables or
queries). You can log the user's entry in startup code, and their exit in
the Close event of a form kept open but invisible the entire life of a
session. Transactions, you will have to define for yourself and write either
to a table in the database or to a file.

There is no "option" setting to automatically do what you want. Many server
databases do have automatic logging features. Access can be used to create
client applications for many server databases, but the one for which most
information is available is Microsoft SQL Server.

Larry Linson
Microsoft Access MVP

"Evelyn Pabón" <ep****@coqui.net> wrote in message
news:Zn****************@fe39.usenetserver.com...

Hi

I created a database application for the company I'm working and as part of the CFR Part 11 it is a requirement for al the application that are for
manufacturing us to have some security option like employee account to log
on in the database and a transaction log to register al the activities that has occurred and saved with the employees name who made the transaction or
the changes.

But I don't have an idea on how to create this transaction log file. Could someone give me a hand on this? I would really appreciate any help.

Thanks,
Evelyn

[Alan Webb]

Evelyn,
I created my own code to do this a few years ago (no, I don't have the
source anymore--it was for a client) in a few days of work. But given the
option I'd go with SQL Server as the back end database because it logs
stuff, has pretty decent security, and is generally the better database over
Jet/Access.

"Evelyn Pabón" <ep****@coqui.net> wrote in message
news:Zn****************@fe39.usenetserver.com...

Hi

I created a database application for the company I'm working and as part
of
the CFR Part 11 it is a requirement for al the application that are for
manufacturing us to have some security option like employee account to log
on in the database and a transaction log to register al the activities
that
has occurred and saved with the employees name who made the transaction or
the changes.

But I don't have an idea on how to create this transaction log file.
Could
someone give me a hand on this? I would really appreciate any help.

Thanks,
Evelyn