[AccessD] DECLARE and SafePtr

[Bill Benson]

Thank you Borge!!

On Sat, Oct 23, 2021 at 1:12 AM Borge Hansen <pcs.accessd at gmail.com> wrote:

> Hi Arthur,
> I've been following your thread re upgrading your Access app from 32bit to
> 64bit.
> I went through the exercise earlier this year.
> I recommend that you have both a 32bit and 64bit version of your Office
> running (on two different machines or VMs of course) to test that the app
> will run both on 32bit version of Office and 64bit version. Your client may
> have a mix of 32bit and 64bit Office.
> If you  have any third party DLLs - or similar - that your app is dependent
> on, make sure that a 64bit version is available.
>
> I used this file:
> Win32API_PtrSafe.TXT
> to help me with the conversion.
> I would search in our vba code for all instances of
> Lib "Kernel32"
> and then copy and paste and search for the specific Declare Function in the
> .TXT file, (I would use Sublime Text for searching the .TXT file).
> Then copy and paste the whole Declare PtrSafe Function over the existing
> Declare ...  Lib "Kernel32" function.
> In only a few instances did I need to include testing - doing a
> #If Win64 then
> - and include the two different Lib "Kernel32" functions...
>
> You can download the
> Win32API_PtrSafe.TXT
> from here:
>
> https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win32api_ptrsafe-with-64-bit-support
>
> Hope  this helps...
>
> /borge
>
>
>
> On Sat, Oct 23, 2021 at 12:12 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > What s the syntax for such a Declare statement/
> >
> > --
> > 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
>