Hi!

As a matter of fact, you don't even have to use ADO...
It seems that, bad use of DAO in the past by a lot of programmers, create this unfortunate scenario with connections...

but u can (with a little change in code) take care of
the whole business.. then again, using ADO will, as u pointed out, take care of it...

Remember though to resync the disconnected recordsets for possible updates

Make it a good day!