I was able to fix this issue by turning OrderByOn off.
So make the Me.OrderbyOn = false the first statemement.
Weird but it works.
Victor Garzon wrote:
Any ideas on how to solve this Issue? I have the same problem.
02-Dec-09
Hey Mate,
I'm dealing with the same exact problem and haven't been able to get it right.
Have you managed to deal with this?
Cheers
Previous Posts In This Thread:
Data Provider Could not be initialized
I am working with Access 2007, SQL server 2005 using MDB and ADO
I have a main form that has a subform datasheet
Subform is bound to an ADO recordset
When I try to Sort the subform it works the first time, but the second time
I get an error "Data Provider Could not be initialized
Same case for filtering. First one works and any subsequent filters bomb
Any ideas would be appreciated?
Thanks
Any ideas on how to solve this Issue? I have the same problem.
Hey Mate,
I'm dealing with the same exact problem and haven't been able to get it right.
Have you managed to deal with this?
Cheers
Workaround
Basically I didn't resolve the issue, I don't think it's possible to get it to work this way. I haven't really, really researched it too much.
I created an easy workaround and that is I created labels and onClick I sort the data. You have to disable shortcut menus on the form to prevent the user from being able to sort it via right-click and add a custom routine to sort.
It's pretty easy, that's why I haven't spent too much time trying to fix it.
Good luck.
Alex
Submitted via EggHeadCafe - Software Developer Portal of Choice
ADO.NET 2.0 DataSet as a Self-Contained, Remoteable Compressed Object
http://www.eggheadcafe.com/tutorial...af83-d9708ea5a3a0/adonet-20-dataset-as-a.aspx