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