For information :
It's a cursor side problem !
By default MS-VB6 use "server side cursor" only alowing Open in "Static
mode" with "Pessimistic Lock".
Setting "CursorLocation=adUseClient" use "client side cursor" alowing Open
in "Dynamic mode" with "Optimistic Lock".
Hard work !...
Luc
>> I use the Open Method from ADO in MS Visual-Basic 6.0 ...
>> Is there anybody who can explain to me why I can't open tables without
>> OIDS ?
>>
>> Thanks.
>>
>> Luc
>>
> Try defining the table as static readonly, and see if that helps.
>
> Shachar
>
> --
> Shachar Shemesh
> Lingnu Open Source Consulting ltd.
> http://www.lingnu.com/
>
>