to make use of the valid relationships in the backup database, without
losing current data, you can: make a copy of your backup backend database,
and make a copy of your "live" backend database (after everyone is out of it
for the day). then try the following, working ONLY with the COPIES you made.

1. delete all records from all tables in the backup db.
2. link in all the tables from the live db.
3. run append queries to copy all data from the linked live db tables into
the backup db tables.
note: this can be tricky. you have to append the data to all "parent"
tables first, before appending data into "child" tables - otherwise, if
referential integrity is enforced in your relationships, Access will not
allow appending "orphan" child records.

and remember to make sure you're working with the COPIES you made of the
backup and live backend databases, not the "real" dbs.

hth


"r. howell" wrote in message
...
A related question: I have pretty much verified that the problem is in
the
relationships of the back end, since switching a front-end over to linking
to
a back-up back end fixes the problem. Is there any way to copy a set of
relationships from one database to another? Or do I have to sketch out
all
the relationships, and craft a repair? If I just switch to the backup,
I'll
lose a week's worth of data, and I'm really reluctant to do that.

"r. howell" wrote:

I'm not sure I can explain this clearly enough to get help, but I'm
going to
try.

I have a bunch of queries, and forms based on those queries which were
working just fine.

I have several front ends which access the same back end.

Somehow, about five forms, based on different queries have stopped
accepting
new entries. Different versions of the front end have the same
problems.

I am fairly confident that I did not mess with the queries, so I assume
that
I somehow deleted or changed a key relationship. Is it the
relationships
that are given in the back end that matter, as I assume? Any wild
guesses as
to what I might have done?

Thanks for any help you can give me, I realize that this is asking for a
wild stab in the dark.