Outlook/access 2k7 - app migration issue, possibly ref lib prob 1

[MollyCoddlez]

K, here goes;

i've created a system that pulls info out of emails and jams them in a database. everything worked perfect on my machine.

i migrated all the code and all the reference library details onto the machine the system needs to run on. however, whenever the process hits the line that opens the record set, it gives me a type mismatch error and halts.

the code is right and works on another machine fine.
the reference libraries used are identical, and they are both on outlook 2k7 in the ThisOutlookSession module.

can anyone help shed some light on wtf is wrong here?

Thanks in advance

 

[PHV]

the reference libraries used are identical
Same order ?
A type mismatch error when opening a recordset is usually due to a non qualified definition:
Dim rs AS DAO.Recordset
or
Dim rs AS ADODB.Recordset

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MollyCoddlez]

thankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyouthankyou

for some reason, on my other machine, ANY recordset i declared could be manipulated in the Vanilla Recordset variable type. as this was the case it just never occured to me. So i changed all my declarations and BAM, it worked.

Thank you. truly