[AccessD] Convert Replcia to Design Master

[Rocky Smolin]

Jim:

Thanks for that link. I'll have to go to the client site and see because I
don't have A97 any more.

I wonder, though, what happens to the primary key when you run the make
table query transferring the records to the new back end?

R

On Tue, May 20, 2025 at 11:25 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
> See if this will do it for you.
>
>  And if you want a link for the MSKB article it references:
>
>
> https://web.archive.org/web/20111215075649/http://support.microsoft.com/kb/1
> 53526/
> <https://web.archive.org/web/20111215075649/http://support.microsoft.com/kb/153526/>
>
>  Never did this myself, so not sure if it will work or not.  Make sure you
> read through the comments.  Couple people had issues, and the author
> pointed
> out pitfalls.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Rocky Smolin
> Sent: Tuesday, May 20, 2025 12:14 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Convert Replcia to Design Master
>
> 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
>