all relationships are gone

[Christopher Glaeser]

Don't know why, but all of the Relationships in my database are missing. A
review of backup files shows they were present until 4/5 and have been
missing since 4/6. Couple quick questions.

- Any ideas on how they may have been deleted? It's a multi-user database,
so I suppose someone could have hit the wrong button. I just recently split
the database and am not sure if that is related. I'm reviewing the timing of
the split now.

- Any suggestions on how to restore the Relationships? Can I restore them
from a backup?

Best,
Christopher

 

[Rick Brandt]

Don't know why, but all of the Relationships in my database are
missing. A review of backup files shows they were present until 4/5
and have been missing since 4/6. Couple quick questions.

- Any ideas on how they may have been deleted? It's a multi-user
database, so I suppose someone could have hit the wrong button. I
just recently split the database and am not sure if that is related.
I'm reviewing the timing of the split now.

- Any suggestions on how to restore the Relationships? Can I restore
them from a backup?

Best,
Christopher

If you just split which file are you looking at? The relationships would be in
the back end (data) file.

 

[david epsom dot com dot au]

1) Check that you don't just mean the relationships
are missing 'from the display window'.

2) It is possible to lose the relationships when you
import the tables into a new database.

3) There is probably code available to walk the database
design in one database and transfer the relationships to
another. There is no Access menu option which does that.

(david)

 

[Christopher Glaeser]

1) Check that you don't just mean the relationships

are missing 'from the display window'.

I'm reasonably certain they are gone. When I create a new query, for
example, Access does not know about any relationships.

I also think I know what happened. I tried to split the database and an
error message was generated. The switchboard was open and Access
complained. So, I closed the switchboard and attempted to split the
database again. This time it worked, or so I thought. I think Access
deleted the Relations from the front-end on the first split, and they were
missing on the second split. Bummer. I assumed everything was still in
tact after the first attempt, but apparently not.

3) There is probably code available to walk the database
design in one database and transfer the relationships to
another. There is no Access menu option which does that.

OK, thanks. Fortunately, I have daily backups, and noticed it within a
week. There are perhaps 30 to 40 relations. I'll just add them back
manually.

Best,
Christopher

 

[Rick Brandt]

I'm reasonably certain they are gone. When I create a new query, for
example, Access does not know about any relationships.

I also think I know what happened. I tried to split the database and
an error message was generated. The switchboard was open and Access
complained. So, I closed the switchboard and attempted to split the
database again. This time it worked, or so I thought. I think Access
deleted the Relations from the front-end on the first split, and they
were missing on the second split. Bummer. I assumed everything was
still in tact after the first attempt, but apparently not.

Did you look in the back end file? That is where the relationships matter.
Relationships in the front end are justy "pretty lines".

 

[Christopher Glaeser]

Did you look in the back end file? That is where the relationships

matter. Relationships in the front end are justy "pretty lines".

Yes, I looked in the be file. That's were they are, in the first be file
that failed during the split. Access complained on the first attempt to
split (it did not like the open switchboard), so I closed the switchboard,
and did the split again. I had assumed it issued the error message before
changing the database. I thought everything was fine, but the first split
had deleted the Relationships. I did not notice they were missing for a few
days. I still have a copy of the failed BE, and the Relationships are
there, but they are missing from the real BE.

Best,
Christopher