Unique Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!
 
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.
 
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.
 
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.
 
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!!!!
 
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.
 
Sorry, I can't figure out the beforeupdate code that I need. Can you help
please??? Thanks!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Structure 11
Vacation Accrual - Challenge 2
Date() help 2
Help needed on Accounting Problem! 2
Converting Date Field to Month 7
how $ much $ for a Custom Access Database? 9
Table Setup - Access 2003 4
Calender 1

Back
Top