hat pretty much solves my problem. Also I found that Access doesn'r support
ODBC updateable cursors until at least Access 2002 (we're using Access
2000), though I thought I had figured out how to get around that and it
didn't work.
I assumed the ODBC driver did support updateable cursors simply because
there is an option in the driver settings called "Updateable cursor"
Thank you for your clarification.
Sim Zacks
IT Manager
Compulab
to email me use: sim "the at sign" compulab "the dot" co "the dot" il
"Alvaro Herrera" <alvherre@dcc.uchile.cl> wrote in message
news:20041113215908.GB12499@dcc.uchile.cl...
> On Tue, Nov 09, 2004 at 01:53:18PM +0200, Sim Zacks wrote:
> > I have a postgresql backend with an access front end and I am trying to
> > redefine the recordset of the form to use an ADO recordset. The problem
is
> > that the CursorType always changes to AdOpenStatic, even if I choose
> > adOpenDynamic. If anyone has any thoughts, please let me know. The form
> > works great for viewing, but I cannot update or insert any new records.
>
> Postgres does not support updatable cursors yet. Maybe that's why the ADO
> driver changes the cursor type from AdOpenDynamic to AdOpenStatic.
>
> --
> Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
> "Nunca se desea ardientemente lo que solo se desea por raz�n" (F.
Alexandre)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>