Compile Error using D8 databas - Microsoft Access Developer 8


	Back to Access Developer 8 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Compile Error using D8 databas

Robert Baker

2 years ago

I'm getting the following error when trying to open the order form in the PCResale Customer Database BEFORE D8.accdb:

COMPILE error:
the code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSave attribute.

Goes to line in code:
Private Delare Function CopyFileA Lib "kernel32" _
(ByVal ExistingFileName as Sgtring, _
ByVal NewFileName As String, ByVal FailIfExists As Long) As Long

db:
PCResale Customer Database BEFORE D8.accdb

Any suggestions on how to fix?

	Robert Baker OP @Reply 2 years ago
I apologize, I should have done some internet research. I found out just inserting the keyword PrtSafe seems to have fixed the problem, so the declare statement reads "Private Declare PrtSafe Function..." with all the rest that follows. Also, I typo'd the first "As Sgtring" should be "As String", of course. The project seems to be working fine now. Sorry to bother you all!

	Kevin Robertson @Reply 2 years ago
Good job figuring this out. This video will give further details: 64-Bit Access

	Robert Baker OP @Reply 2 years ago
Thanks for the reply, Kevin, and the reference to Rick's 64-bit video! That verifies my research. I'm happy the solution is so simple. Maybe someday I'll get into API calls in my programming, but for now I'm keeping it basic. Thanks again!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer 8.

Next Unseen

New Feature: Comment Live View