[AccessD] Upsizing ACCDB to SQL Server

[Jim Dettman]

Rocky,

 If you use Win API calls, yes.

 Besides that, you might need to update some of the calls, and some calls
are different between 32 and 64 bit, meaning you'd need to use complier
constants, or maintain two separate versions.

 But if an app is all straight native Access, then no.   Just open the DB in
64 bit Access and you are off and running (if it's an .accdb).

Jim.

-----Original Message-----
From: AccessD On Behalf Of Rocky Smolin
Sent: Tuesday, October 19, 2021 10:48 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Upsizing ACCDB to SQL Server

Isn't there also something that you have to do with SafePtr?

Rocky


On Tue, Oct 19, 2021 at 4: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?vi
ew=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
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com