By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,214 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,214 IT Pros & Developers. It's quick & easy.

Help - Log Transaction

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.