"Miller, Sam" wrote:
>
> Hiroshi and others,
>
> Nope....
>
> Also tried (randomly):
> -Disabling KSQO
> -Enabling "Unknowns as LongVarChar"
> -Enabling Parse Statements
> -Enabling Show System Tables
> -Switching to 6.3 Protocol
>
Please try
Set rs = conSource.OpenRecordset("Select * From data2", dbOpenDynaset, _ dbExecDirect, dbOptimisticValue)
and never forget to set the DefaultCursorDriver property.
regards,
Hiroshi Inoue