From: Elmar Schalueck <Elmar.Schalueck@ruhr-uni-bochum.de>
To: pgsql-interfaces@postgreSQL.org
To: byronn@insightdist.com
Subject: Problems with Update in Access, ODBC
Date: Wed, 27 May 1998 13:43:14 +0100
Message-ID: <199805271143.HAA04861@hub.org> (raw)
Hi there,
I am using (version 06.30.0242) of your PostgreSQL ODBC driver to work with
MS-Access as a nice to look interface to my PostgreSQL 6.3 DB.
Some problems occur when I try to use Access-Form to update imbedded tables.
What happens: I add some external tables via ODBC, and Access asks for the
fields that make up a unique qualifier for each table. In my app it is an
integer as the record number.
When I try to change some entries, I have a crash of Access. It tries to update
UPDATE transferstellen SET telefon='02461/6009 1017',telefax='02461/6009 1090'
WHERE kennummer = 2 AND teil = 'A' AND hochschule = 'Fachhochschule Aachen' AND
organisation = 'Technlogie- und Wissenstransfer' AND organisation2 = '' AND
gebaeude = '' AND strasse = 'Kalverbenden 6' AND plz = '52066' AND ort =
'Aachen' AND bundesland = 'NRW' AND telefon = '0241/6009 1017' AND telefax =
'0241/6009 1090' AND email = 'wagner@fh-aachen.de' AND www =
'http://www.fh-aachen.de/official/fhac/twt/twit.html'; AND lastchange =
'1998-05-26'
Why don't you use the unique field (kennummer for me), Access claims to know
about. Is is my mistake to work like this? What can I do?
Regards
Elmar
---
Dr. Elmar Schalueck
Ruhr-Universitaet Bochum
BIF
Projekt ELFI
D-44780 Bochum
Tel.: 0234/700-6182
Fax : 0234/7094-684
EMail: Elmar.Schalueck@ruhr-uni-bochum.de
WWW: http://www.elfi.ruhr-uni-bochum.de
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: Elmar.Schalueck@ruhr-uni-bochum.de, byronn@insightdist.com
Subject: Re: Problems with Update in Access, ODBC
In-Reply-To: <199805271143.HAA04861@hub.org>
* 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