[AccessD] Convert Replcia to Design Master

[Rocky Smolin]

"the creator's working environment." Aye, there's the rub. No creator
available. :-(

(No archives either. My client has scoured all the places where the Design
Master might be. )

This is why I got out of the business. ;-)

r

On Tue, May 20, 2025 at 1:59 PM James Button via AccessD <
accessd at databaseadvisors.com> wrote:

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