[AccessD] Convert Replcia to Design Master

[Rocky Smolin]

Doug:

Still biking as much as possible.  Old age caught up with me, now riding an
electric Pinarello road bike.

If I can't solve this client's problem without a lot of coding I'm going to
look for someone to pass it to. Know any candidates?

Best,

r

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

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