This link addresses your problem.

http://support.microsoft.com/support.../Q278/4/08.ASP

To fix this you must replace the constant adOpenDynamic with adOpenKeyset or adOpenStatic.