[AccessD] Convert Replcia to Design Master

[jamesbutton at blueyonder.co.uk]

>From wide experience -
There should be a set of scripts to:
create flat file sets of data from the tables,  
create the database table structures
set the linkages  and views
load the tables from the flat files.

Ideal place to look for those would be the creator's working environment.
And then the regression and UAT testers ones.

Maybe you'll even find there is still a "user" environment for the tester, and DBA that includes all that -
Well except for the current data.

It's the sort of thing that IT support teams consider worth archiving -
And may even contain test and working validation scripts and required result check sets.

Been there - returned to a large systems provider as a consultant - systems conversion and validation specialist
 and found the complete environment I had setup years before to not only still be on the site, 
but the id I had used was still active - even using the same password ! 
Main problem was getting past the new windows security checking and Apps that did not like the old format documents on what to do with what!

JimB

-----Original Message-----
From: AccessD <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Tuesday, May 20, 2025 7:55 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Convert Replcia to Design Master

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