[AccessD] Convert Replcia to Design Master

[Stuart McLachlan]

Does this help?

https://microsoft.public.access.setupconfig.narkive.com/YHww1Wd0/lost-designmaster-for-replicated-database

On 20 May 2025 at 9:13, Rocky Smolin wrote:

> 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