Error 13: Type Mismatch

[D Collins]

Hello,

I recently upgraded to Access 2002. Before the upgrade,
the database worked correctly, but now when I try to run
a form that has code behind it, I get the Error 13: Type
Mismatch error.

Would anyone know what might have happened when I
upgraded to cause this error? Is there an invalid
reference somewhere?

Thanks, D.

 

[Eric Butts [MSFT]]

Hi D,

Check your library references. You may be missing something "Microsoft DAO
3.6 Object Library"

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

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

--------------------
| Content-Class: urn:content-classes:message
| From: "D Collins" <[email protected]>
| Sender: "D Collins" <[email protected]>
| Subject: Error 13: Type Mismatch
| Date: Mon, 9 Aug 2004 08:50:47 -0700
| Lines: 12
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcR+KKMZEWG0igvdQ1GcueGj6CpuBA==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.setupconfig:30897
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| Hello,
|
| I recently upgraded to Access 2002. Before the upgrade,
| the database worked correctly, but now when I try to run
| a form that has code behind it, I get the Error 13: Type
| Mismatch error.
|
| Would anyone know what might have happened when I
| upgraded to cause this error? Is there an invalid
| reference somewhere?
|
| Thanks, D.
|

 

[Douglas J. Steele]

Actually, I'd suspect that they'd removed the ADO reference, and it came
back, so that their Recordsets are being treated as ADO, not DAO.

Bottom line, D, is compare the references from a machine where it works to
where it doesn't work. (To check references, open the VB Editor using
Ctrl-G, then select Tools | References from the menu)