[AccessD] Upsizing ACCDB to SQL Server

[Arthur Fuller]

Thanks, Jim. I'll start working on it. First the BE and then the FE.

On Tue, Oct 19, 2021 at 7:39 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> Arthur,
>
> 1.  SQL Server Migration Assistant:
>
>
> https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?vie
> w=sql-server-ver15
> <https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15>
>
> 2. Any Win API calls will need to be updated.    Also any external libs,
> .OCX's, Active-x controls, etc.   all need to be 64 bit.   Can give you
> more
> detail on that if you need it.    But if it's all native Access, then you
> just switch and a recompile is all that is required if you are distributing
> apps as .accde's.  If it's an .accdb, it will re-compile on the fly.
>
>   Note that from Office 2013 and up, you cannot mix and match 32 bit and 64
> on the same machine.  It all has to be one or the other.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Arthur Fuller
> Sent: Tuesday, October 19, 2021 7:28 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Upsizing ACCDB to SQL Server
>
> This is actually two related questions:
> 1. What is the recommended way to upsize an Access ACCDB to SQL Server?
> 2. The client also wants me to move the app from 32 bit to 64 bit, What
> potential problems am I looking at?
>
> Thanks.
>
> --
> Arthur
> --
> 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
>


-- 
Arthur