Error when trying to use ADO

[Marc H]

I am new to Access and maybe I missed something. When I use the ADO syntax I
get a message that I am trying to use an undefined user type. So I have been
using the DAO syntax instead. Is there a pre-step where I set up Access 2007
to see the ADO library? Thanks.

 

[Clifford Bass]

Hi Marc,

In case you have not figured it out yet: While in the VB Editor goto
to Tools menu and then References. You will then need to select the most
recent Microsoft ActiveX Data Objects 2.n Library item.

Clifford Bass