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@xxxxxxxxxxxxx> wrote in message news:20041113215908.GB12499@xxxxxxxxxxxxxxxx > 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 > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
