[AccessD] Upsizing ACCDB to SQL Server

[Stuart McLachlan]

We've discussed PtrSafe and when and how to use it here many times - including in threads 
you started.  (I've got 104 messages in my AccessD mail folder that mention it)

Last September, you seemed to know a bit about it when you said:

"I develop in 2010. I keep things simple so I don't run into problems with
folks who use later versions.  The only problem I've had is with those who
use 64-bit access and that is worked around with PtrSafe. "

:)


On 19 Oct 2021 at 7:48, Rocky Smolin wrote:

> 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-assis
> > tant?vie w=sql-server-ver15
> > <https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assi
> > stant?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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>