How to resolve the [Run-time error '424', Object requred] when running an Access 2003 application with an mdb type file?
Posted on 2010-11-15
I am developing an Access 2003 application using an MDB type file.
When I run the application on my PC, the application runs successfully.
When I run the application on another user's machine, I get the following error:
Run-time error '424':
And if I set a breakpoint in the Access application, I get a different run-time errror of '429'.
Do you know how I can resolve this error?
I notice the following in the Tools -> References: Available References
Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microosoft DAO 3.6 Obj Library
Microsoft Active X Data Obj 2.5 Library
Microsoft Excel 11.0 Obj Library
Microsoft Office 11.0 Obj Library
Microsoft Outlook 11.0 Obj Library
And in the application the following 2 dlls are used:
Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
Private Declare Function RegOpenKeyEx Lib "advapi32.dll" _
Alias "RegOpenKeyExA" (ByVal hKey As Long, ByVal lpSubKey As String, _
ByVal ulOptions As Long, ByVal samDesired As Long, _
phkResult As Long) As Long