I have recently upgraded my system to Office 2010 64 bit. My employees are still using my database - form on Office 2003. I opened and made some minor changes to their form and now I’m getting some errors.
“Your database or project contains a missing or broken reference to the file ‘ACEDAO.DLL’ version 12.0”
Any ideas?
I corrected one error by adding,
#If VBA7 And Win64 Then
Private Declare PtrSafe Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
#Else
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
#End If
“Your database or project contains a missing or broken reference to the file ‘ACEDAO.DLL’ version 12.0”
Any ideas?
I corrected one error by adding,
#If VBA7 And Win64 Then
Private Declare PtrSafe Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
#Else
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
#End If