ACCESS FEED: RE: [MS_AccessPros] corrupted database

Kamis, 31 Juli 2014

RE: [MS_AccessPros] corrupted database

Gary,

That does help. It will take some time to build the form but I will get started.

Also, one more question. When the database does a compact and repair I seem to loose primary keys and relationships in about 5 tables, always the same tables. I have to go in and fix them and then it all works well again. Any Idea why that would happen?

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, July 30, 2014 1:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] corrupted database

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