Re: error with access 2003 - column "ctid" does not exist

"Jeff Eckermann" <jeff_eckermann@xxxxxxxxx> wrote in message
news:20040719135214.30472.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx
> I am thinking that you could just include "ctid" in
> the select list for your view, and everything would
> work.  The only issue would be, in the case of a
> multitable view, which available ctid value you
> choose.  I suspect that the choice will not make a
> difference.
>

Neither explicitly including ctid in the select list, or implicitly
excluding ctid by specifying individual columns will work.

I tried using different recordset parameters, and found one that works, at
least with the simple test recordset that I posted:

CursorLocation = adUseClient
    - Have to use client-side rather than server-side cursor engine, at
least with current     ODBC driver

CursorType = adOpenStatic
    - Can only  use static cursor if client-side cursor engine specified,
per docs
    - adOpenStatic is used with adUseClient, no matter what is specified in
code
    Verified this by examining recordset properties in the VB "locals"
window

If this is correct, might be useful to put somewhere in FAQ.

David P. Lurie




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)