[AccessD] Convert Replcia to Design Master

[dw-murphy at cox.net]

Hi Rocky,

Not doing any Access consulting any more, fired my last client last year. I do some Access applications for organizations I belong to. Mainly to keep the few remaining active neurons stimulated. Not helping much.

Are you still biking north county?

Doug

-----Original Message-----
From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Wednesday, May 21, 2025 10:02 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Convert Replcia to Design Master

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