Tracy:
There are no built in auditing features that I am aware of in Access.
Through a form, you can place a date/time stamp using the expression
"Now()" when the record updates, then build a query that will poll the
date/time stamp field with whatever criteria you specify (between DATE
and DATE, >DATE, etc).
You use the example of an upcoming audit. The audit date (or a date when
the record was added to the table) must be in the record. The query can
pull those records based on a date criteria.
Open fields can be found using the "Is Null" criteria.
Thomas C. Nield, MCP
Electronic Records Archivist
Records Management Division
Missouri Secretary of State
600 W Main, Rm. 153
Jefferson City, MO 65102
Phone: 573-751-7299
Fax: 573-526-5327
E-mail: [log in to unmask]
-----Original Message-----
From: Records Management Program [mailto:[log in to unmask]] On
Behalf Of Tracey Black
Sent: Tuesday, April 03, 2007 2:15 PM
To: [log in to unmask]
Subject: Re: Access Database Functions
Tom,
We are looking to track any changes to the database for auditing
purposes.
Qt 2, More or les you answer with the second part of your reply.
Polling for open fields within a record, or a reminder for an upcoming
audit or something like that.
Thanks,
Tracey
-----Original Message-----
From: Records Management Program [mailto:[log in to unmask]] On
Behalf Of Nield, Tom
Sent: Tuesday, April 03, 2007 2:31 PM
To: [log in to unmask]
Subject: Re: [RM] Access Database Functions
Tracey:
Regarding question 1, what kind of auditing are you referring to?
As for question 2, are you asking if Access can close itself when
logging off of Outlook? For reminders you can create a macro named
"autoexec" that runs when the database is opened. The macro itself can
open queries that can poll the data looking for the conditions that
require a reminder.
-----Original Message-----
From: Records Management Program [mailto:[log in to unmask]] On
Behalf Of Tracey Black
Sent: Tuesday, April 03, 2007 12:05 PM
To: [log in to unmask]
Subject: Access Database Functions
Dear Listserv,
I have a couple questions regarding Access Databases:
1. Does Access have any auditing capabilities?
2. Is there any way the database can be linked to Outlook with
reminders or signoff capabilities?
Tracey Ann Black
Records Administrator
www.mmwec.org
413-3081272
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
List archives at http://lists.ufl.edu/archives/recmgmt-l.html
Contact [log in to unmask] for assistance
|
