From: Brian Haney <brian@cybernaut.com>
To: pgsql-interfaces@hub.org
Subject: RE: access97-Recordset not updatable
Date: Tue, 14 Dec 1999 12:36:01 -0800
Message-ID: <000701bf4672$d5e84b90$8101a8c0@specter.fresno.cybernaut.com> (raw)
In-Reply-To: <199912132057.PAA83780@hub.org>
Kevin wrote, in part:
> I can create the DSN on my windows98 machine and have configure the
> driver so that all read-only options are NOT selected. Using Access97,
> I have no problem viewing table data from the Postgres server, but
> whenever I try to modify an entry, I get the error: This Recordset is
> not updatable.
I found the same problem using Excel 97. It went away after I installed the
latest Micro$oft Data Access Components and Office 97 Service Releases 1 and
2a. I just noticed that 2b is out now. I'm not sure exactly what fixed it,
but mine seems to work.
There are additional pre-reqs: Your table must have a unique index (a
primary key will do) and the recordset must be of type Dynaset (the default,
I think). I have not succeeded in updating views, however, even with unique
indices and appropriate rules for insert and update events on those views.
Please let me know if you have success and if this information solved the
problem.
MDAC:
http://download.microsoft.com/download/dasdk/mdac/2.1.2.4202.3/W9XNT4/EN-US/
mdac_typ.exe
Office 97 Service Releases:
http://officeupdate.microsoft.com/Articles/sr2fact.htm
--Brian Haney
brian@cybernaut.com www.cybernaut.com
President 800-762-8849
CyberNautix, Inc. UNIX and Internet Solutions for the Digital Economy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: brian@cybernaut.com, pgsql-interfaces@hub.org
Subject: RE: access97-Recordset not updatable
In-Reply-To: <000701bf4672$d5e84b90$8101a8c0@specter.fresno.cybernaut.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox