Re: Lost Relationships

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Recreate them. As you probably know, they are essential to the integrity of
your data.

I have experienced Access losing some relationships, but never all of them.
Typically it happens when a primary key field index, so Access removes the
index, and so the relations that rely on that index are removed also. This
is a rare occurrance, and it is extremely unlikely that all your primary key
indexes went corrupt at once.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Carrie" <Carrie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4085D543-CF38-4F0F-9E78-20A705CD0DE5@xxxxxxxxxxxxxxxx
Hello, I have a front end and a back end for my database (Access 2000) and
my
relationships seem to have disappeared but the db is still working just
fine.
I am the only one that has access to the backend and I know I did not
remove
them. I have tried show all and show direct in both the fe and be but no
relationships appear. I have been searching the web and found a couple
suggestions:

(CTRL + G) ?currentdb.Relations.Count which gives me 0 and

for each rel in currentdb.Relations: debug.Print rel.name, rel.table,
rel.foreigntable: next rel

This seems to do nothing. I have a backup that does show all the
relationships so technically I could set them all up again but am not sure
if
I should. Is my database corrupt? Should I redo the relationships?
Thanks
a lot.


.

Relevant Pages

  • Re: Referential Integrity
    ... This is a number field since the Primary Key it the ... >> record has been entered without referential integrity ... I get an error message saying Data in ...
    (microsoft.public.access.forms)
  • Re: Changing values in Primary and Secondary keys
    ... Do this by draging and dropping the primary key field ... You need to check "Enforce Referential Integrity" and "Cascade ... secondary keys that have a relationship to the primary key will get updated ...
    (microsoft.public.access.gettingstarted)
  • Order of records in a table? Db corrupt?
    ... from my Delphi 5 application using TAdoConnection and TAdoTable. ... I expect to read the record ordered by the primary key. ... Am I wrong i expecting, that reading records like above, is equivalent to ... Is the database corrupt? ...
    (borland.public.delphi.database.ado)
  • Re: Difference between "Unique Index" and "Primery key Index"?
    ... Primary key is used for implementing referencial ... integrity. ... CREATE UNIQUE INDEX ... ... The second one will define a primary key constraint (which comes with a ...
    (microsoft.public.sqlserver.programming)
  • Linking tables by autonumber
    ... I created two tables and chose ID and autonumber as my ... primary key in both and joined the tables. ... integrity and cascade on delete are accepted but when I ...
    (microsoft.public.access.tablesdbdesign)