Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
-----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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relative Path in Connection String | Excel Discussion (Misc queries) | |||
Globally change an Access connection string | Excel Discussion (Misc queries) | |||
Pivot Table Connection String - How to hide it? | Excel Discussion (Misc queries) | |||
How do I use a connection string? | Excel Discussion (Misc queries) | |||
What is the connection string ? | Excel Programming |