Error 2013 Access

[mfmalthaf]

Hi,



I had created a MS access in 2003 version of office. After my lap top was updated to Office 2013, the command buttons of this MS access are not working.
im getting a VBA error, saying "the code in this project must be updated for use on 64-bit..." (Please see the attchement)

How to solve this error.

[ranman256]

I had to retrofit my functions for some users who had 64 bit os.
check to see if user is OS64, then apply PtrSafe to each function:

#If Win64 Then
    Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpszOp As String, ByVal lpszFile As String, ByVal lpszParams As String, ByVal lpszDir As String, ByVal FsShowCmd As Long) As Long
    Private Declare PtrSafe Function GetDesktopWindow Lib "user32" () As Long
#Else
    Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpszOp As String, ByVal lpszFile As String, ByVal lpszParams As String, ByVal lpszDir As String, ByVal FsShowCmd As Long) As Long
    Private Declare Function GetDesktopWindow Lib "user32" () As Long
#End If

[ItsMe]

Another option may be to not install Office as 64bit and install office 32bit. IIRC the PtrSafe is only needed when running Access 64bit.

[ranman256]

I have Access 32 bit, run on 64bit OS and it runs without PtrSafe ,
but 1 persons 64 PC would not use the functions until I did the PtrSafe .