update a front-end database with a new release using vba

[aldi07]

Declare Function apiCopyFile Lib "KERNEL32" Alias "CopyFileA" _
                   (ByVal lpExistingFileName As String, _
                   ByVal lpNewFileName As String, _
                   ByVal bFailIfExists As Long) As Long

I get the following compile error:

The code in this project must be updated to use on 64-bit systems. Please review and uodate Declare statements and the mark them with the PtrSafe attribute.

How do I do that?

Thank you.

 

[dhookom]

Same answer I provided in the other forum. Did you s check it out?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[aldi07]

I did, but the web site did not open. However, I retried right now, and I could finally reach it.
"Declare Function...", should be replaced by
"Declare PtrSafe Function..."
It seems it will work, since the statement has been accepted without error.
I will run it, and let you know.
Thank you.

 

[aldi07]

It worked fine. Thank you Duane

 

[dhookom]

Please mark the correct post so other users know the thread is closed.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[aldi07]

OK. Here it is:

Declare PtrSafe Function apiCopyFile Lib "KERNEL32" Alias "CopyFileA" _
                   (ByVal lpExistingFileName As String, _
                   ByVal lpNewFileName As String, _
                   ByVal bFailIfExists As Long) As Long