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(at)enigma(dot)net http://www.enigma.net
-----------------------------------------------------------