Bill-
If you're losing indexes every time you compact / repair, I would strongly recommend building a new database and importing all the objects from the old one. There's something broken in those tables that might be fixed by doing that.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 1, 2014, at 8:30 AM, 'Gary D. Schwartz' gary.schwartz@pobox.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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:
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]
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 di
--------------------------------------------------------
Gary D. Schwartz Please reply to: gary.schwartz@pobox.com __._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Yahoo Groups
New Feature! Add Polls to Conversations
You can now include a poll directly within your message. Members can view, vote and add poll options either via email or on the group. Try it today!
.
__,_._,___
Tidak ada komentar:
Posting Komentar