[AccessD] Convert Replcia to Design Master

[Rocky Smolin]

Thanks Doug. Nice to hear from you. Are you still in the Access game?

I'm going to put this one in my back pocket in case all other avenues fail.

Best,

r

On Wed, May 21, 2025 at 9:13 AM <dw-murphy at cox.net> wrote:

> Check this article.
> https://stackoverflow.com/questions/19889879/de-replicate-an-access-database
>
> Doug
>
> -----Original Message-----
> From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On
> Behalf Of Rocky Smolin
> Sent: Tuesday, May 20, 2025 9:24 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Convert Replcia to Design Master
>
> 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
> >
> --
> 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
>