Re: adOpenKeyset changes to adOpenDynamic

What is causing the switch?

ADO is allowed to coerce CursorType and LockType if what you asked for is
not available. So be prepared for that.

On the switch:
Sometime ago I produced a printed table of requested
CursorLocation/CursorType/LockType and what was returned for SQL Server. I
found that for server-sided cursors, whether a table had a primary key or
was indexed made a difference. Check database 2 - see if tables have the
relevant indexes that database 1 has.

Stephen Howe


.