Frontend lost relationships and field names

[Brigitte P]

I am helping another facility with a database. There backend data was
imported so I could do my part. After I completed, I deleted the tables so I
could forward the frontend to them and they could relink to their backends.
But disaster struck because the frontend lost all relationships and field
names in the queries; I just got Exp1: Name, Exp2 Town .... whatever. I
compacted and repaired but nothing fixed it. I fixed the field names, but the
relationships in the queries were also lost. Tables were there but no
relationships. Obviously, a quick fix won't work there because I don't recall
on top of my head wheter I had left, right or whatever joints. I have done
this many times and never had a problem; why now. Is there an easy fix and
how can I prevent this in the future. I'm just now re-doing all my work.
As always, many thanks for your help.
Brigitte P.

 

[Jeff Boyce]

Brigitte

A quick fix? Are you asking if Access might have saved a copy of the
relationships? I really doubt it (I'm not aware of any).

Do you have a backup of your database from before you deleted the tables?

For the future, there's no reason you'd have to delete something if you use
a back-end for the data/tables and linked to those. You would need to have
the users re-link to THEIR back-end tables. This assumes your users (and
you) have the application split into front-end and back-end.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Brigitte

One more thing...

If you've created new back-end relationships, unless you substitute your new
back-end .mdb file for the users, they won't see it... no matter what you
may have done in the front-end component.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Brigitte P]

Jeff,
Sorry, I didn't think anyone replied so I just now read your suggestions.
Well, I was able to replicate the problem. Here is what I did, and as a
warning to others what not to do. 1) I deleted the tables from the working
copy of the frontend, 2) Compacted/Repaired, 3) linked to the new backend.
Step 2) killed the relationships and fieldnames because, obviously, there
were none. I had a backup, but in my office not in my remote location 300
miles roundtrip away.
Back in my office, I worked from the backup and 1) deleted all tables, 2)
linked to the new backend, 3) Compated/Repaired and allis well.
Expensive lesson learned, and thanks for your input.
Brigitte P.