G
guy.jara
I got caught up on this and I wanted to put it out into the ether. I
was experiencing a problem where a Jet SQL query was throwing an error
over the use of the very common MID function in the SQL statement. I
checked references and I had a reference to the VBA library, as well
as the Access 11.0 object library.
Then I checked with a colleague and they directed me to establish a
reference to the MS Visual Basic for Applications Extensibility
library. When I added that to my list of references, voila!, problem
solved.
was experiencing a problem where a Jet SQL query was throwing an error
over the use of the very common MID function in the SQL statement. I
checked references and I had a reference to the VBA library, as well
as the Access 11.0 object library.
Then I checked with a colleague and they directed me to establish a
reference to the MS Visual Basic for Applications Extensibility
library. When I added that to my list of references, voila!, problem
solved.