Can't get connection string right
-----Original Message-----
When I set the connection string of an ADODB.Connection
to
this and try to run a command, I get the error
message, "Requested operation requires an OLE DB Session
object, which is not supported by the current provider"
Just to terminate my own post:
I don't know what the heck; I was adding messages in my
code so I know the code was running. I had the ADO code
in the event handler for a hyperlink, and it would never
work. Next thing you know, I hit F5 in the VBA window and
the code ran and worked (added a record to a database). I
then clicked the hyperlink and it worked there too.
|