Received: from www.enigma.net (www.enigma.net [199.45.123.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id RAA88575
	for <pgsql-interfaces@postgresql.org>;
	Thu, 15 Jul 1999 17:19:16 -0400 (EDT)
	(envelope-from apollo@enigma.net)
From: apollo@enigma.net
Received: from barney (199.45.123.4) by www.enigma.net
	(Rockliffe SMTPRA 1.2.2) with SMTP id <B0000156669@www.enigma.net>;
	Thu, 15 Jul 1999 17:14:10 -0400
Message-Id: <3.0.3.32.19990715171429.00932bb0@enigma.net>
X-Sender: apollo@enigma.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.3 (32)
Date: Thu, 15 Jul 1999 17:14:29 +0600
To: pgsql-interfaces@postgresql.org
Subject: 
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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