Thread:

From
apollo@enigma.net
Date:
15 July 1999, 17:19:34
Running a small VB app within MS Access 97 to copy data using DAO.
ODBC 6.40.0006
PSQL 6.5
Client: Win NT

PostgreSQL DB opens fine. Can link tables as a test and they are updatable.

I open the recordset (cursor) as a dynaset type (keyset) and get the
following error upon executing a '.AddNew' method on the recordset.

"Cursor is not valid"


Have tried different combinations of ODBC driver settings including
defaults plus:

Rec Unique Index
Use Declare/Fetch
Parse Statements

minus:
Read onlys


Any ideas would be appreciated.






-----------------------------------------------------------
Don Youdale                                 Enigma Software
apollo@enigma.net                     http://www.enigma.net
-----------------------------------------------------------