Skip site navigation (1) Skip section navigation (2)

Problems with Update in Access, ODBC

From: "Elmar Schalueck" <Elmar(dot)Schalueck(at)ruhr-uni-bochum(dot)de>
To: pgsql-interfaces(at)postgreSQL(dot)org, byronn(at)insightdist(dot)com
Subject: Problems with Update in Access, ODBC
Date: 1998-05-27 12:43:14
Message-ID: 199805271143.HAA04861@hub.org (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)fh-aachen(dot)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(dot)Schalueck(at)ruhr-uni-bochum(dot)de
WWW: http://www.elfi.ruhr-uni-bochum.de

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-05-27 13:07:07
Subject: Re: Problems with Update in Access, ODBC
Previous:From: Massimo Dal ZottoDate: 1998-05-26 21:36:20
Subject: Re: [HACKERS] Time to fix libpgtcl for async NOTIFY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group