3633 - Cannot Load DLL: '?????L?'

[TJLMO]

I need to include various dll, olb, and tlb files with a VBA application I have created for Business Objects. This works fine on my PC because the files are already there. When I move it to a user's PC, however, and I attempt to run the function CreateWorkspace from the DAO360.dll library, I receive the error in the subject heading. I have included the application extensions with the application, but still run across this error.

I check to make sure the references are there using:

For Each lref_Ref In Application.VBE.ActiveVBProject.References
If lref_Ref.IsBroken Then
ls_RefPath = CStr(lref_Ref.FullPath)
Application.VBE.ActiveVBProject.References.AddFromFile (ls_RefPath)
End If
Next

but this does not help with the problem.

Any ideas?

Thanks.
-TJLMO

 

[vb5prgrmr]

You will need to install the MDAC that you can download from MS at...

http://www.microsoft.com/data/download.htm

What you are looking for is the jet components.

Good Luck

 

[TJLMO]

Call me a beginner, but what is an alpha machine?

 

[TJLMO]

I loaded MDAC 2.5 to the user's machine and this did not solve the problem. Any other ideas? Thanks.

 

[vb5prgrmr]

You are one version too low. Check out the following article from MS.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q271908&

You need MDAC 2.6 and JET 3 or 4

 

[vb5prgrmr]

Make that Jet 4SP3

 

[rwalkup]

I see that this thread pretty much died on October 9th, but nobody seemed to really answer the question. The problem that you are getting is related to the msrdo20.dll. It IS NOT part of the MDAC or JET installations. Please refer to MS Knowledgebase article:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q260369

I pulled my hair out for 2 days because I searched the knowledgebase with "Cannot Load DLL" instead of "Can't Load DLL" - finally after searching through a filemon (from sysinternals.com) log, I found the difference in the working and non-working machines was this one simple file. Hope this helps someone out there - wish I had found it earlier.