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