problem reading table from VB code

[nello87to]

Hello,


i am trying to read a table defined in an access project with a vb module but i have this kind of error:


This is the error: User-defined type not defined
I have found this code online and i have adapted it for my function.
Someone know if i must define something else to read fields from a table?

thank you all

[ranman256]

i occasionally get this error, so do this....
dont define rst as recordset, instead use variant then open rst using openrecordset command....

dim rst 

set rst = currentdb.openrecordset(sql)

[ssanfu]

I have never used ADO, only DAO. But I did find a couple of pages that might help:
https://www.aspfree.com/c/a/Microsof...cess-with-ADO/
https://www.aspfree.com/c/a/Microsof...ccess-and-ADO/


Do you have a reference set to "Microsoft ActiveX Data Objects 2.8 Library"??

[nello87to]

It works using variant and openrecordset command.
I didn't have set the reference "Microsoft ActiveX Data Objects 2.8 Library".
Probably this was the problem. Next time i will try setting this reference.

thank you all
and good work!