Click here to Skip to main content
15,899,754 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
Hi
On Windows 7,Upon Compilation of ms-access2010 application , have a error message stating Error Loading in dll , is their a way to check a dll which is not getting loaded . I have checked all the references none of them are missing.

I have put the following code which tells which are all the references being made
VB
On Error Goto ErrorTrap
Dim Strlist as String
Dim ref as Access.Reference

For Each ref In Access.References
 strList = strlist & Ref.Name &"....."& ref.FullPath &" "& vbCrLF
Next ref

VBA.MsgBox Strlist

ErrorTrap:

If VBA.Err.Number<>0 Then
  Select Case VBA.Err.Number 
       Case -2147319779
            StrList = strlist & Ref.Name &"....."&"*** MISSING****" & " " & VbCrLF
Resume Next
End Select
VBA.MsgBox Vba.Err.Number &" "& VBA.Err.Description
End If  

Upon running the above code , the message box was displayed with MSoSOAPLib30 missing

Then I downloaded MSSOAP30.dll and placed it on the location c:\Programfiles\Common Files\Microsoft Shared\Office14 and regestiering it with regsvr32 , this to also throwed me an error like some binary components pertaining to this file is missing.


Is their any difference between 32-bit MSSOAP30.dll and 64-bit MSSOAP30.dll can i know them and is MSSOAP30.dll used on Xp having a comapatiblity problem on Windows7. Please help me resolve this problem

Thanks
Posted
Updated 7-Jun-12 17:55pm
v2
Comments
Sergey Alexandrovich Kryukov 8-Jun-12 0:22am    
"On error", "Goto"... is it VB6 or something? Any particular reason to dig in all this garbage? :-)
--SA
mmsgk251804 8-Jun-12 0:44am    
Its VBA
Sergey Alexandrovich Kryukov 8-Jun-12 11:00am    
Tag it, to start with.
--SA

1 solution

this may happened If you are 64 bit office and you try to load 32 bit dll
or may a problem in your dll
 
Share this answer
 
Comments
mmsgk251804 11-Jun-12 0:29am    
SO how do i register the dll as 64 bit on windows 7 machine and how to check the dll is having any problem ?
NewPast 11-Jun-12 1:35am    
check that dll documentation or
please put the dll name that make the error or
it on office 32 bit version and it worked well; this mean it is 64bit
mmsgk251804 13-Jun-12 5:24am    
MSSOAP30.dll
mmsgk251804 13-Jun-12 5:25am    
Checked all the refernces are clean.
NewPast 13-Jun-12 7:26am    
MSSOAP30.dll is 32 bit and only could be used in 32 bit office version
if need it please use office 2010 32 bit version not 64 bit version
but please note: that You don't need the SOAP dll to connect to web services. uses the MS XML 3.0
please see the following link:
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/using-mssoap30dll-with-office-2010/ba1c6723-b274-4bb7-a048-4a810c54ee81?msgId=6fc775a9-1f70-4624-82f5-1484a904a772

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900