I had a similar issue on a multi-table database, where I need to verify
before/after maintenance or backup work.
I built a form where I have a field for each table I want to review.
Inside that field, I built an event using this code:
=DCount("[indexfield]","[tablename]")
An index field is used as there is always a value in every row. I believe
that
it only counts rows where that field is occupied.
I monitor about 40 different tables this way, and print out the form before
and
after. I added a field that displays the current date/time, which is
included in
the printout.
Hope this helps,
Gary
Original email:
-----------------
From: Bill Singer' Bill.Singer@at-group.net [MS_Access_Professionals]
MS_Access_Professionals@yahoogroups.com
Date: Wed, 30 Jul 2014 12:31:56 -0500
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] corrupted database
Every once in a while I have a problem with a database and it compacts and
repairs.
It then tells me to check to see if I have lost any records. Usually I know
what table to look at but I should check to see if there are any missing
records.
Is there any way to see how many records are in each table without opening
each table? It would really save me a lot of time.
Thanks for the help.
Bill
MN
----------------------------------------------------------
mail2web LIVE Free email based on Microsoft Exchange technology -
http://link.mail2web.com/LIVE
Posted by: "gary.schwartz@pobox.com" <gary.schwartz@pobox.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar