Compile error, code must be updated for use on 64-bit system

[mike02]

Hey, I have put my DB my shared network, and everyone was able to connect there front end to the back end easily. My issue is the i recieved this error on one of the pcs:

Compile Error:

The code in this project must be updated for use on 64-bit systems.
please review and update Declre statements and then marke them with the ptrSafe attribute.




it is new and the store put everything on thepc for us. I have found a microsoft link, http://support.microsoft.com/kb/983043 but i am still have this error after implementing this procedure.

[RuralGuy]

Have you used the If...Else for each of your Declare values?
http://msdn.microsoft.com/en-us/libr.../gg278832.aspx

[June7]

I ran into this error trying to run db on Windows 7 64-bit machine because of this code in module header:

'API function to disable the X Close button is for 32-bit machine
Private Declare Function GetSystemMenu Lib "user32" (ByVal hwnd As Long, ByVal wRevert As Long) As Long
Private Declare Function EnableMenuItem Lib "user32" (ByVal hMenu As Long, ByVal wIDEnableItem As Long, ByVal wEnable As Long) As Long

The PtrSafe keyword works when running db on the Windows7 64-bit but on WindowsXP 32-bit it won't compile so I am not sure what that MSKB article was trying to instruct. If it won't compile how can it be backwards compatible? If Vba7 is supposed to be intrinsic constant, it doesn't return a value, nor does Vba6.

The VBA editor version can be found by: Application.VBE.Version

I also had a variable declared as integer to hold RecordCount of a recordset but had to change to long or double (forget which worked, didn't save).

[mike02]

ok, thanks, ill give it a shot!