Most likely a references issue. The confusing part is that you stated that the code runs
fine on another PC....
Are you running this test on the *same exact copy* of the .MDB file? Or, is there a
chance that you have done some modification to the copy of the .MDB file that is on the PC
experiencing the problem? If you've made any changes, such as importing all objects into
a new DB container, you may have a missing reference to the DAO library, or you may have a
priority issue with the ADO library.
PRB: Error 13 Type Mismatch Error on DAO OpenRecordset Method
http://support.microsoft.com/default.aspx?scid=kb;en-us;181542
_____________________________________
Need a help to know why some pc running a program comes out with the error
message "data type mismatch", but running with another pc it's work fine
and no such error come out.