pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedaccess97-Recordset not updatable
3+ messages / 2 participants
[nested] [flat]
* access97-Recordset not updatable
@ 1999-12-13 17:06 Kelvin O. Lim <lim@nki.rfmh.org>
0 siblings, 0 replies; 3+ messages in thread
From: Kelvin O. Lim @ 1999-12-13 17:06 UTC (permalink / raw)
To: pgsql-interfaces
I am using the current psqlodbc driver (6.40.0007) with Access97 to
communicate with a Postgresql server (6.5.3) running on a Solaris
platform. The Postgres server has been working fine; I have a php/apache
application which has been working smoothly.
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.
Any pointers about what I may be doing wrong would be greatly
appreciated.
Thanks,
Kelvin Lim
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: access97-Recordset not updatable
@ 1999-12-14 20:36 Brian Haney <brian@cybernaut.com>
0 siblings, 0 replies; 3+ messages in thread
From: Brian Haney @ 1999-12-14 20:36 UTC (permalink / raw)
To: pgsql-interfaces@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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: access97-Recordset not updatable
@ 1999-12-20 17:17 Kelvin O. Lim <lim@nki.rfmh.org>
0 siblings, 0 replies; 3+ messages in thread
From: Kelvin O. Lim @ 1999-12-20 17:17 UTC (permalink / raw)
To: brian@cybernaut.com; pgsql-interfaces@hub.org
Brian,
I just wanted to get back to you. Your message was very helpful. I
went back and
found out that I had NOT specified a unique index when I linked the
external table from Postgresql into my Access97
database. After I did this, everything worked fine.
Kelvin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-12-20 17:17 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-13 17:06 access97-Recordset not updatable Kelvin O. Lim <lim@nki.rfmh.org>
1999-12-14 20:36 RE: access97-Recordset not updatable Brian Haney <brian@cybernaut.com>
1999-12-20 17:17 RE: access97-Recordset not updatable Kelvin O. Lim <lim@nki.rfmh.org>
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