Solved Convert to 64-bit

[Kayleigh]

Hi, I came across the attached sample database but having trouble converting to run on 64-bit machine. Can anyone help me please?

 

[theDBguy]

Hi. I don't have 64-bit to test this, but you could start out by adding PtrSafe anywhere you see Private Declare. For example,

Private Declare PtrSafe Function VirtualAlloc...

Hope that helps...

 

[Uncle Gizmo]

See Here:-

upgrading to 64 bit access

I am chaning to 64 bit and i get the error message that it cannot compile. The code in this project must be updated for use on 64 bit systems. Please review and update declare statements and then mark

answers.microsoft.com

 

[theDBguy]

See Here:-

upgrading to 64 bit access

I am chaning to 64 bit and i get the error message that it cannot compile. The code in this project must be updated for use on 64 bit systems. Please review and update declare statements and then mark

answers.microsoft.com

Amazing! How on earth did you find that thread? I am wondering now if that utility is not 64-bit compatible.

 

[Uncle Gizmo]

Amazing! How on earth did you find that thread

Well, I tried to convert it to 64bit, but it failed on one of the subs, so I searched on the erroneous sub, and found that thread.

Unfortunately, it's still not working!

I suspect some of the "Longs" need changing to ptrsafe longs. The OP will need to research on that I believe.

 

[theDBguy]

Well, I tried to convert it to 64bit, but it failed on one of the subs, so I searched on the erroneous sub, and found that thread.

Unfortunately, it's still not working!

I suspect some of the "Longs" need changing to ptrsafe longs. The OP will need to research on that I believe.

Thanks for the update. I am wondering if the "native code" is a 32-bit piece of code that may not work in 64-bit. I'll need to find the original source and see if there's any explanation about that.

 

[isladogs]

The only developer I know who uses native code in Access is Wayne Phillips so the original file was easy to track down.
Access/VBA Tutorials - Accessing detailed file information provided by the Operating System (everythingaccess.com)
I've checked and it doesn't work in 64-bit.

However I have a similar utility which works in both 32-bit & 64-bit.
See Extended File Properties - Mendip Data Systems

Hope that helps

 

[theDBguy]

The only developer I know who uses native code in Access is Wayne Phillips so the original file was easy to track down.
Access/VBA Tutorials - Accessing detailed file information provided by the Operating System (everythingaccess.com)
I've checked and it doesn't work in 64-bit.

However I have a similar utility which works in both 32-bit & 64-bit.
See Extended File Properties - Mendip Data Systems

Hope that helps

Thanks! That's what I figured may be the case.

 

[arnelgp]

don't use Crystal's version (it only works for x32).
go further down that site and download the one with link "sample database file".
this one is x64-ready.

 

[Kayleigh]

Thanks for researching this!