I have some code that worked a week ago, but doesn't anymore.  I have two
adodcs.  When a user makes a selection in a list controlled by adodc1 my
code changes the RecordSource for adodc2, then calls adodc2.Refresh.

This worked great a week ago using an Access database with Jet 3.5.1.
During the week I upgraded to Office 2000.  I decided to update my database
to Jet 4.0 so that I can continue to work with it in Access.  Now I get an
Unknown error when calling adodc2.Refresh (returns E_FAIL).

I can't find anything about a known bug in MSDN, and after playing with this
for hours do not see a way out.  I have code like this all over in my
project.  Anyone have ideas how to fix this?

Thanks,

Jarrod Ribble