[AccessD] Upsizing ACCDB to SQL Server

[James Button]

See
<
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-he
lp/ptrsafe-keyword>
 
A way to check in the code if the environment is 64 bit or 32 
Not a good idea to run a 64 bit script on a 32 bit OS 

And when creating the script you will not know what setup a target system
actually has!


JimB

-----Original Message-----
From: AccessD
<accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of
Arthur Fuller
Sent: Tuesday, October 19, 2021 5:19 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Upsizing ACCDB to SQL Server

Rocky,
I have no idea. I've never even heard of it. Of course, since I retired and
then got dragged back in (c.f. Michael Corleone), times have changed. In my
opinion, the old way was better. Client didn't pay, you whacked him. Clean
and simple. But now we have to have lawyers and such. Sheesh.
Speaking of which, have you seen *Lansky,* starring Harvey Keitel?

On Tue, Oct 19, 2021 at 10:48 AM Rocky Smolin <rockysmolin2 at gmail.com>
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-assistant?vie
> > w=sql-server-ver15
> > <
>
https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sq
l-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
>


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