[AccessD] Upsizing ACCDB to SQL Server

[Jim Dettman]

When you upsize, don’t forget to add a TS (TimeStamp or Rowversion depending on the version of SQL you are using) field to every table.

 

This is an option in SSMA which should be on by default, but double check.

 

That allows JET/ACE to work with the table efficiently when updating.

 

Jim.

From: Arthur Fuller 
Sent: Tuesday, October 19, 2021 7:50 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: Re: [AccessD] Upsizing ACCDB to SQL Server

 

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 <mailto:accessd at databaseadvisors.com> > wrote:

Arthur,

1.  SQL Server Migration Assistant:

https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?vie <https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15> 
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 <mailto: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 <mailto:AccessD at databaseadvisors.com> 
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com <mailto:AccessD at databaseadvisors.com> 
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




 

-- 

Arthur