[AccessD] Upsizing woes

[John Colby]

I feel your pain.  At the company I wrote the call center for, I walked by
a cube to find a user trying to do stuff.  She had taken a course on Access
and thought she'd add some fields to a table.  A linked table.  I gently
explained that modifying tables had consequences beyond what she understood
and she was not allowed to do that.  I thought it best not to explain links
and where the real table was.  Just in case.

On Sun, Sep 6, 2020 at 8:18 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> I' still using Office 2010 so that I can support clients using anything
> from 2010 onwards.
>
> One old client is using a system I originally built in Access 2000 (using
> .mdb FE/BE)
>
> The probllem is they are an oil palm company based in East New Britain
> province several
> hours from the nearest airport.  That and COVID-19 travel restrictions
> mean everything is
> being done remotely.
>
> First step was to get their latest FE and upgrade it to an accdb that
> would work n both 32bit
> and 64 bit.  Done successfully.
>
> Next task to upsize to SQL Server 2014.  I got a copy of the old 77MB BE
> .mdb and coverted
> it to accdb.  I then used the upsizing wizard  but the upsize failed on
> some tables.
>
> It appears than some years ago, they had someone who liked to tinker who
> deleted some
> records after removing refertial integrity, leaving lots of orphans.  -
> they also did a few other
> naughty things.
>
> There were inappropriate dates (like "10/1/143") in the system which SQL
> Server wouldn't
> accept.  There were also a few records with corrupt data in them.
>
> I finally got it all cleaned up and imported and the clean .accdb sent
> back to the client to do
> the upsize.
>
> They are using Office 2013.
> That's when we discovered that there is no upsize wizard in Access 2013
> onward. It's been
> "depreciated".   SIgh!
>
> I'm urrently downloading the SQL Server Migration Assistant (SSMA) for
> Access so that I can
> check it out and write a process description for them.
>
> (Sorry folks, I just had to vent to someone who would understand :) )
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting