Err.Number: 48 Error in loading DLL

[Dave]

All of a sudden I am getting the following error in my Access database
application when I click on a command button.

ERROR: F_ArticleList.cmdSelect_Click
4/22/2006 7:31:47 PM
Err.Number: 48
Err.Description: Error in loading DLL



The error occurs on the line indicated in the following procedure:

Private Sub cmdSelect_Click()
On Error GoTo ErrHandler
'open the detail for this record in frmArticleAnd Topic

'is the form open?
Dim i As Integer
For i = Forms.Count - 1 To 0 Step -1
If Forms(i).Name = "F_ArticleTopic" Then

'if F_ArticleTopic is open, move to current record
With Forms!F_ArticleTopic.RecordsetClone
.FindFirst "ArticleID = " & str(txtArticleID) <----error occurs
here *****
If .NoMatch Then
MsgBox "Record not found"
Else
Forms!F_ArticleTopic.Bookmark = .Bookmark
End If
End With

End If
Next

'Now close
DoCmd.Close


ErrHandlerExit:
Exit Sub

ErrHandler:
Debug.Print "ERROR: F_ArticleList.cmdSelect_Click"
Debug.Print Now()
Debug.Print "Err.Number: " & Err.Number
Debug.Print "Err.Description: " & Err.Description
Debug.Print "----------------"

MsgBox "Error No: " & Err.Number _
& "; Description: " & Err.Description

Resume ErrHandlerExit:
End Sub



This application was working fine for some time and the problem only just
started occurring.

I have done the following troubleshooting steps:

I tried repairing my Microsoft Office Professional 2003 installation
through the repair option in the Control Panel Add/Remove Programs app
Checked for updates to make sure I am using Office SP2
Upgraded the mdb database file to Access 2002-2003 format
Downloaded the MDAC Com checker and ran it. It says I am using MDAC 2.8 SP1
and shows one mismatch:

<group name="MISMATCH" count="1">
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="MSADCO.DLL" dir="%COMMONFILES%\system\msadc\">
<release name="MDAC 2.8 SP1 on Windows XP SP2" version="2.81.1117.0"
fileversion="2.81.1117.0" />
<found xmlns="" Description="Microsoft Data Access - Remote Data Services
Data Control" date="03/23/2006" fileVersion="2.81.1124.0
(xpsp_sp2_gdr.060322-1613)" size="143360" version="2.81.1124.0" />
<result xmlns="" mismatch_fields="version" />
</file>
</group>

Checked KB and Google for the issue. I get a number of hits but either there
is no resolution or its not applicable.

I am using Windows XP SP2 that has a version of SQL 2000 on it.

Has anyone seen this issue before? Could it be a virus?

 

[Stefan Hoffmann]

hi Dave,

All of a sudden I am getting the following error in my Access database
application when I click on a command button.
ERROR: F_ArticleList.cmdSelect_Click
4/22/2006 7:31:47 PM
Err.Number: 48
Err.Description: Error in loading DLL
Has anyone seen this issue before? Could it be a virus?

It's not a virus. Irc register your DAO Dll manually.


mfG
--> stefan <--

 

[Wei Lu]

Hi Dave,

Thank you for using MSDN Managed Newsgroup Support.

The error message you got specified that a dynamic-link library (DLL) can't
be loaded. This is usually because the file specified with the Lib clause
in the Declare statement is not a valid DLL.

Possible causes for this error are:

The file is not DLL-executable.
The file is not a Microsoft Windows DLL.
The file is an old Microsoft Windows DLL that is incompatible with
Microsoft Windows protect mode.
The DLL references another DLL that is not present.
The DLL or one of the referenced DLLs is not in a directory
specified by your path.

Please try to register the DAO dll:

a. Click Start, and then click Run.
b. In the Open box, type Regsvr32.exe
C:\progra~1\common~1\micros~1\dao\dao350.dll
c. Click OK.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Dave]

Thanks Wei

I registered manually and got a message that the registration was
successful.

However, I am still getting the Error 48 : Errr loading DLL message.

Here is what else I have tried:

1. Downloaded the Component Checker and ran a diagnostic against MDAC 2.8
SP1.

I got one mismatch file: MSADC0.DLL: Expected version 2.81.1117.0 but actual
versio 2.81.1124.0. This is the Remote Data Services Data Control so I do
not think this is directly related to the problem. All other file, COM and
registry details are matches.

2.In the References list of the VBA module, the DAO library was marked as
"MISSING". I cleared the reference and reset it first as Microsoft DAO
2.5/3.5 Compatible Library and then as Microsoft DAO 3.51 Object Library.
Neither of these options solve the error messaage.

3. When I create a brand new database file and try to create a form, I get
the nessage: "Object Library not registered" I click okay and it lets me
create the form. If I check my references in VBA, none of the DAO libraries
are available but I can scroll doen and add references for either
Microsoft DAO 3.51 Object Library or Microsoft DAO 2.5/3.5 Compatible
Library. THere is no Microsoft DAO 3.5 Object Library

4. I do have a DAO350 file at:

C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL 557 KB
4/27/98 1:00 AM.

Also in this folder are

dao360.dll 549 KB 8/24/04 1:56 AM
Dao2535.tlb 72 KB 7/28/98 2:54 PM

5. In Add/Remove Programs I uninstalled the MS Access Application and then
reinstalled it. This also did not help.



I am at a loss as to where to go from here. Can anyone offer a suggestion?

Thanks
Dave

 

[Wei Lu]

Hi Dave,

I think you may need to register the latest version of the DAO. Please
register the DAO360.dll to have a try.

Also, please try to add the Microsoft DAO 3.6 Object Library

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------