[AccessD] Convert Replcia to Design Master

[Rocky Smolin]

Looks promising. But there is no facility like this in A97. I've got A2003
herer and I can take a look at that, but the mdb is in 97 format so it may
need to be upgraded to 2002-2003 format before it will agree to the change
to Design Master. We'll see.

Thanks

r

On Tue, May 20, 2025 at 4:15 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

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