[AccessD] DECLARE and SafePtr

[Borge Hansen]

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
>