Unique Problem

G

Golfinray

I was hired 3 months ago to update and maintain an Access database for the
state. I am writing queries and forms and so forth as needed but I am also
entering data. No one has added data to this database in months - they had
just kind of "let it go" until they got someone hired. Now my boss wants to
know "what percent of the database has been updated. Is there a way to tell
how much of a database has changed in the last 3 months/last week/last day?
Help please!!! Thanks so much!!!!!
 
D

Douglas J. Steele

Sorry, no.

If you're going to need this information on an ongoing basis, add a new Date
field to each table and set its default to Now. That'll let you know when
each new record got added.

If you need to know updates as well, you'll need to ensure that all updates
are done using forms, and put logic in the form's BeforeUpdate event to
provide the current date/time to update the field.
 
D

Dennis

Not without a DATE field that gets set whenever a new record is added or an
existing record has changed. You'd have to code it, since it's not a part of
Access' database infrastructure. Even restoring an old copy and comparing the
tables would be an onerous task. Yuck.
 
I

In Need of Help

If you have a regular backup system, you can check the backups for the
database and see how much data was entered as of those backups.
 
G

Golfinray

Everything is entered through forms. I tried the beforeupdate and I could not
get the code correct for what I need. Help! What would that code need to look
like. Thanks!!!!
 
D

Dennis

First, you would have to create fields in all tables for the date/time values.

Let's say you call that field "DateTimeLastUpdated"

In the BeforeUpdate event for a table update (not an ADD if you default the
value to NOW() in the table itself, which would place a correct
date/timestamp in for a new record automatically), you'd place this code:

Me.DateTimeLastUpdated = Now()

All done.
 
G

Golfinray

Sorry, I can't figure out the beforeupdate code that I need. Can you help
please??? Thanks!!!!
 
Top