ADODB object problem

[Anonymous]

Hi all!.
I can't use ADODB object.
I don`t know why.
When i compiled VBA sendme a message "Type mismatch"
In the list of references, i can't found ADO.
How can load this reference?

thx for all,
PS.

[Anonymous]

Reference name is:
Microsoft ADO Ext. 2.8 For DLL and Security
I use MS Office 2003
Mabe you need to check Reference to:
Microsoft Access 11.0 Object Library also

Hth

~'J'~

[Anonymous]

Thx Fatty for reply, buy i check both reference and nothing.
Maybe something more.

thx for your help.

[Anonymous]

wrote in message news:5435490@discussion.autodesk.com...
>Reference name is:
>Microsoft ADO Ext. 2.8 For DLL and Security

Fatty,
that's for adox (related but different)

for adodb
Microsoft Activex Data Objects 2.xx


>I use MS Office 2003
>Mabe you need to check Reference to:
>Microsoft Access 11.0 Object Library also

you don't need access to use ado

To OP,
post your actual code
You wouldn't get a Type Mismatch error from a missing library
You'd get a "User defined type not defined"

[Anonymous]

MP and Fatty.

This Working!, Thank you to both.

Pato.

[Anonymous]

Oh, my bad
I knew it
Thanks anyway 🙂

~'J'~