[AccessD] Convert Replcia to Design Master

[dw-murphy at cox.net]

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