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
-----------------------------------------------------------