Not sure if this is the right forum but I'll give it a try:
I have an unbound subform, the ADODB recordset of which, is set to a stored proc on SQL Server.
It works fine ordinarily; if however i just leave it sitting open on my screen for a short time, I get a host of "Data provider could not be initialized" errors appear.
I dont have any Timer events set, yet it seems to happen when the screen is refreshing itself.
I've looked through the other forums and haven't found a conclusive answer.
Any suggestions?
I have an unbound subform, the ADODB recordset of which, is set to a stored proc on SQL Server.
It works fine ordinarily; if however i just leave it sitting open on my screen for a short time, I get a host of "Data provider could not be initialized" errors appear.
I dont have any Timer events set, yet it seems to happen when the screen is refreshing itself.
I've looked through the other forums and haven't found a conclusive answer.
Any suggestions?