Bill-
John,
I am about to start this process. Is there a specific process for doing this? Some have said to do one item at a time and do a compact repair in between each item. Or do I just do copy over all the items and do compact repair once?
Thanks,
Bill
MN
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, August 1, 2014 8:39 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] corrupted database
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:
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 (9) |
Tidak ada komentar:
Posting Komentar