Table loosing keying

[JoeElla]

I have an Access 2000 data base which has been loosing the keys on one of the
tables. This data base is five years old and this problem has happened
infrequrently in the past, but lately it is happening every few days. I
would appreciate any ideas.

 

[Allen Browne]

Loosing the keys?

If you are talking about a table where the foreign key field is found to be
Null, this typically happens when the user enters a record in a subform when
the main form is at a new record. In this case, the foreign key field
inherits the Null from the new record in the parent form. Note that this
problem occurs even if you have created a relation between the 2 tables with
referential integrity enforced.

To prevent the problem, fix (or delete) any records where the foreign key is
null. Then open the related table in design view, and set the Required
property of the foreign key field to Yes.

 

[John Vinson]

I have an Access 2000 data base which has been loosing the keys on one of the
tables. This data base is five years old and this problem has happened
infrequrently in the past, but lately it is happening every few days. I
would appreciate any ideas.

Indexes (including primary keys) disappearing? I've seen similar
problems, but always in circumstances where somebody COULD have been
(intentionally or not) meddling. 2000 was a somewhat flaky release
though so it's quite possible!

Check out the corruption suggestions at

http://www.granite.ab.ca/access/corruptmdbs.htm

In particular, make sure that Name Autocorrect is turned OFF.

John W. Vinson[MVP]

 

[JoeElla]

Thank you John. I will check out that article.

Allen The data is there but the table is no longer keyed.

 

[JoeElla]

John,
I checked name auto correct on the offending DB and it was selected.
Thank you so much for the help.