Tenho uma Base Access que começou a dar este erro

Copper Contributor

 

Antonio1959_0-1644434212350.png

 

3 Replies
As the message makes clear, you need to update the API declarations for 64-bit.

Do you have a question?

@isladogs 

 

Como faço isso?

@Antonio1959 

You need to convert each API declaration adding PtrSafe and converting Long to LongPtr for handles and pointers.

If any users are still running A2007 or earlier you will need conditional compilation.

The likelihood is that the above info made little sense to you ... so I strongly recommend you do some research on the topic. Its a complicated topic when you first encounter the issue

There are many articles online but there is a lot of misinformation so take care.

I recommend the following article:

Windows API declarations in VBA for 64-bit - Codekabinett

Also this documentation from MS

https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win32api_ptrsafe-with-64-bi...

 

This conversion utility may also help:

Windows API Viewer for MS Excel (rondebruin.nl)

 

Hope that helps

Alternatively, uninstall 64-bit Office and revert to 32-bit Office !