Received: from sunu450.rz.ruhr-uni-bochum.de (sunu450.rz.ruhr-uni-bochum.de [134.147.222.33]) by hub.org (8.8.8/8.7.5) with SMTP id HAA04861 for ; Wed, 27 May 1998 07:43:54 -0400 (EDT) Message-Id: <199805271143.HAA04861@hub.org> Received: (qmail 12418 invoked from network); 27 May 1998 11:43:41 -0000 Received: from bif-5.uv.ruhr-uni-bochum.de (HELO bif-fno-1-183-2.uv.ruhr-uni-bochum.de) (134.147.201.64) by mailhost.rz.ruhr-uni-bochum.de with SMTP; 27 May 1998 11:43:41 -0000 Comments: Authenticated sender is From: "Elmar Schalueck" Organization: University of Bochum To: pgsql-interfaces@postgreSQL.org, byronn@insightdist.com Date: Wed, 27 May 1998 13:43:14 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Problems with Update in Access, ODBC Priority: normal X-mailer: Pegasus Mail for Win32 (v2.54) 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