ACCESS FEED: RE: [MS_AccessPros] corrupted database

Rabu, 27 Agustus 2014

RE: [MS_AccessPros] corrupted database

Gary D. Schwartz

This function for running a list of how many records are in each table
worked great. I put it in a report so I print it out periodically.

Thanks,

Bill

Ph: 763-754-8898

Toll Free: 877-902-8898

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 1, 2014 8:30 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] corrupted database

When I built the form, I recall a lot of cut-n-paste, then going back and
changing the formula in each one.

As for your new question, I do not remember ever seeing that.

A little more detail on version setup and the specific problem would be
helpful in diagnosing, and perhaps someone else here will have more
experience with this problem.

Gary

At 11:43 AM 7/31/2014, you wrote:

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

MN

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals@yahoogroups.com> [
mailto: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
<mailto: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 di

--------------------------------------------------------

Gary D. Schwartz Please reply to: gary.schwartz@pobox.com
<mailto:gary.schwartz@pobox.com>

[Non-text portions of this message have been removed]