You receive a “Type mismatch” error when you run the OpenRecordset method

http://support.microsoft.com/kb/181542

You get this error when you run vb code without having the right references set to the proper priority in Microsoft Access databases.

Follow the directions from the link above to resolve the issue.