[AccessD] Upsizing ACCDB to SQL Server

[Rocky Smolin]

Oh, yeah, huh.  It's not the storage, it's the retrieval.

r

On Tue, Oct 19, 2021 at 2:22 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>