At a guess this is because the references in your database have got out
of order, and
Dim RecClone as Recordset
is declaring an ADODB recordset instead of a DAO recordset (which is
what Form.RecordsetClone returns).
You can avoid the problem by using fully qualified types in your
declarations, e.g.
Dim RecClone As DAO.Recordset
I installed a full version of access 2002. I successfully, I believe,
imported all objects and
converted it and my data to 2002 format. The db window has (Access 2002 File
Format)
in the caption bar.
This seems occur every time I upgrade to a new version but I can never
remember how I
remedied the situation. When I try to open my main form I get a Error 13
Type Mismatch
on line marked below.
Private Sub Form_Current()
Dim RecClone As Recordset
Dim intCount As Integer
Dim intPosition As Integer
Set RecClone = Me.RecordsetClone() 'debugger points to this line.
I also created a reference, which I didn't have, to Microsoft DAO 3.6 Object
Library.
Is all this correct? Can I or should I remove the references to Microsoft
ActiveX Data Objects??
If it was upgraded from Access 97 you probably don't need the reference
to ADO but you do need the reference to DAO.
Declaring DAO worked.
I also created a reference, which I didn't have, to Microsoft DAO 3.6 Object
Library.
Is all this correct? Can I or should I remove the references to Microsoft
ActiveX Data Objects??
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
