Jumat, 06 April 2012

Re: [MS_AccessPros] Major data issues.

 

John

I guess that I have a long weekend ahead of me. I do have missing data in the fields. I guess that it worked on the form and subforms because of the relationships that were set and the master child links on the forms. 
 
Jim Wagner
________________________________

________________________________
From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, April 5, 2012 11:21 PM
Subject: RE: [MS_AccessPros] Major data issues.


 
Jim-

I've seen a discussion on another forum where the PK and relationships on a
table disappeared. Apparently, JET will drop the relationships and the indexes
if data in the table becomes corrupted. It's a very rare occurrence, and not
likely to happen on more than one table at a time. If all the PKs are missing
in your tables, then it's probably not this "bug."

One way to clean it up is to import all the tables – structure only – into a new
database. Rebuild all the Pkeys and relationships, then link to the old tables
one at a time and run an Append query from the old to the new. That should drop
duplicates and get rid of unlinked child records. Note that you'll have to do
this one table at a time working down from the top of your relationship tree.
For example, you'll have to do Customers before Orders.

Good luck!

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

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

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Thursday, April 05, 2012 11:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Major data issues.

 
Hello All,

I have just looked at the data tables I had built for a client and I am
horrified. I had the table relations correct and the tables designed with PK's
and everything. But as I look at the design, the PK's are not set and the
related field data in each table is either missing or has a 0. They do not have
the knowledge on what to do in the table design so I must have taken the PK off
at sometime and did not put it back.

Somehow the relations have kept the records on the forms working but I am at a
loss on what should my next move be. They did an audit and the records all match
based on the forms, but the tables are a mess.

Any Suggestions

Jim Wagner

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

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar