[AccessD] Convert Replcia to Design Master

[Jim Dettman]

See if this will do it for you.

 And if you want a link for the MSKB article it references:

https://web.archive.org/web/20111215075649/http://support.microsoft.com/kb/1
53526/

 Never did this myself, so not sure if it will work or not.  Make sure you
read through the comments.  Couple people had issues, and the author pointed
out pitfalls.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Rocky Smolin
Sent: Tuesday, May 20, 2025 12:14 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Convert Replcia to Design Master

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com