I have been having a problem with MS Access over the last several days.  One
of the associated dll files is not working properly.  An error is encountered
with existing code.  To correct the error I reselect the reference(dll) for
Microsoft DAO 3.51 Object library and the application began returning error
messages on code that was not modified.  The problem first happened in an
Access 97 application.  Then it occured in an Access 2000 application that
uses SQL Server tables.  The problem presented itdself on three seperate
computers.

Here is the code I ran and the error I got.

Sub Report1(StartDate As Date, EndDate As Date)
Dim db As Database, rst As Recordset, SQL As String, SQL2 As String, I As
Integer
Dim Division As String, QDF As QueryDef, qn As String

Set db = CurrentDb

SQL = "SELECT Division.Description FROM Division;"
Set rst = db.OpenRecordset(SQL, dbOpenDynaset)

Returns - Error Number - 13
               Error Description - Type mismatch

Any suggestions are most welcome.
BCP