[AccessD] Upsizing ACCDB to SQL Server

Jim Dettman jimdettman at verizon.net
Tue Oct 19 06:39:05 CDT 2021


Arthur,

1.  SQL Server Migration Assistant:

https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?vie
w=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



More information about the AccessD mailing list