[AccessD] Convert Replcia to Design Master

[Rocky Smolin]

Dear List:

I was contacted by a former client who is using Access 97 FE & BE. That
solution is no longer effective. They want to switch to a more
updated version of office - the target is Office 365.

To go to anything past about 2010 they will need to have the format of the
be first updated to 2002-2003 format. Doing this required making changes to
the back end.

However the production BE they're using is a Replica and they cannot find
the Design Master and all instructions I can find on converting a Replica
to a Design Master require the Design Master to be present.

A further complication is that a few of the tables in the BE are corrupted,
but they are only using functions which hit the uncorrupted tables,
AFAICT.  However, that a side issue.

Doing a direct import of the (uncorrupted) tables does not work. I can copy
and paste the records but then the PK gets lost, so the child tables would
not have the correct FK. I can do this if I can take off the PK but no
design changes are allowed in the Replica.

There is a Relationships diagram so I can see where the FKs might be and I
suppose I could read the records from the Replica and, having retrieved the
Replica record, save the Replica PK, insert the record into the new back
end, the retrieve each of the records in the other tables, and replace the
FK there with the new record's PK. But that's a bunch of programming I'm
hoping will not be necessary.

So, if there's a way to get this Replica into Design Master format, that
would certainly be a shorter distance between the two points.

ANY ideas would be welcome

MTIA,

Rocky