Answers inline....
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Tim Drury" <tdrury@NetVendor.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Monday, October 09, 2000 3:15 PM
Subject: [INTERFACES] faq/archives & question
>
> A few questions (being new here):
>
> (1) Is there a way to get to this lists' mail archives?
http://www.postgresql.org/mhonarc/ And just go to the relevant folder.
>
> (2) Is there a PostgreSQL *interfaces* faq? I've read
> the primary PostgreSQL faq?
>
> (3) Using Access/postdrv v6.5 to access my postgresql
> ver 7 database works fine, but I cannot write to it.
> I've turned off both "read only" checkboxes on the
> settings dialog for the driver. When I enter a value
> into a field, it let's me type it in, but when I try
> to move the cursor away from that field I get the
> error: "ODBC--call failed. Connection is readonly,
> only (#1)".
After you remove all the read only boxes (2 of them?), you need to relink
your tables. I encountered the same problem... if you make a change to the
ODBC driver, all the tables need to be relinked in Access to notice the
changes.