Error 13 - Mismatch

J

Jose Perdigao

I have a database BE/FE in access 2003.
The FE in some computurs open very well, without errors.
In some computers when I open, appears the error 13. I ignore and it works
fine.
I don't understand why in some computurs or in some access 2003 is ok,
others is not. Is it missing any file?

Any ideas?

Thanks,
José Perdigão
 
A

Allen Browne

Both the DAO and ADO libraries have a Recordset object. The "type mismatch"
error suggests you are getting the wrong one. The difference might be to do
with what libraries are installed on each machine.

Try specifying the type you want:
Dim rstMain As DAO.Recordset

More info about libraries, and which ones you need for each version of
Access:
http://allenbrowne.com/ser-38.html
 
J

Jose Perdigao

Always I spdeify dim str as dao.recordset.
Both libraries are installed in all machines.
msado25.tlb and DAO360.dll

There is no missing libraries

So, I don't know what's happened.

Any ideas?

thansk,
josé perdigão
 
A

Allen Browne

Some of the later versions of the ADO library do not handle JET.

If you have problems, try referencing msado21.tlb instead (i.e. Microsofr
ActiveX Data Objects 2.1)
 
J

Jose Perdigao

I will try but doubt still continuos becuase in some machines I have
msado25.tlb and it works fine others the error appears

Thanks,
José Perdigão
 
Top