Unable to save relationships/Access 2003

[ColinD]

I have a backend database in which I am attempting to build relationships,
but I find I cannot save them. When I save, close the window, and reopen it,
the relationships have gone, though the tables are still there are. It
happens whether or not I enforce referential integrity.

The problem occurs on one particular database. I have tested it on another
and all is ok.

We have recently migrated from 97 to 2003, and the relationships that were
created earlier in 97 have been saved. When I open the window, only my new
relationships have been lost, the old ones are still there.

Many thanks,
Colin Dimond

 

[Allen Browne]

Suggestions:

1. Make sure you are in the database where the tables exist (i.e. not merely
attached tables.)

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

3. Then compact the database:
Tools | Database Utilities | Compact/Repair

 

[ColinD]

No luck I am afraid. I have tried this and also tried importing the tables
and relationships into a new blank database with the box unchecked. Thanks
anyway-any other ideas, Allen/anybody else?

Many thanks,
Colin

 

[Allen Browne]

If the relationships don't save with local tables when Name AutoCorrect is
off, then is a corruption in the database.

You could try programmatically deleting all relations:
http://allenbrowne.com/DelRel.html
Then compact, and see if you can create and save a relation.

 

[ColinD]

That did the trick! Many thanks for your help Allen.

Colin