[AccessD] Upsizing ACCDB to SQL Server

[Rocky Smolin]

Haven't seen it.  But we don't get netflix, hulu, or any of the other
premiums because we don't watch much TV.

r

On Tue, Oct 19, 2021 at 9:21 AM Arthur Fuller <fuller.artful at gmail.com>
wrote:

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