I have built an application on excel to add and modify data on access (I used microsoft office 2007 31 bits version) everything works great!
I tried the application in another computer that has microsoft office 2013 64 bits version and it seems to have problem with the DAO reference!

When I run the application it put me "error 429" " object creation threw activeX component not possible "
The error comes on this line (the second line):
 refe = ThisWorkbook.Path & "\HMT Gerätedatenbank.mdb"
    Set basedonnee = DAO.OpenDatabase(refe)
I heard maybe the reference of DAO is not supported in access 2013 application !

And also when I use this code (because I open a pdf file fril the userform so I use an API)
'Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
'(ByVal hwnd As Long, ByVal lpOperation As String, _
'ByVal lpFile As String, ByVal lpParameters As String, _
'ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
The application tells me "The code in this project must be updated for use on 64-bit systems" and put something named Ptr (I don't know at all what this is!!)

Can anyone help me?
Thank you !!