pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Problems with Update in Access, ODBC 2+ messages / 2 participants [nested] [flat]
* Problems with Update in Access, ODBC @ 1998-05-27 12:43 Elmar Schalueck <Elmar.Schalueck@ruhr-uni-bochum.de> 0 siblings, 0 replies; 2+ messages in thread From: Elmar Schalueck @ 1998-05-27 12:43 UTC (permalink / raw) To: pgsql-interfaces; byronn@insightdist.com 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Problems with Update in Access, ODBC @ 1998-05-27 13:07 Byron Nikolaidis <byronn@insightdist.com> 0 siblings, 0 replies; 2+ messages in thread From: Byron Nikolaidis @ 1998-05-27 13:07 UTC (permalink / raw) To: Elmar Schalueck <Elmar.Schalueck@ruhr-uni-bochum.de>; +Cc: pgsql-interfaces Elmar Schalueck wrote: > 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 > When you say "crash of Access", what do you mean exactly? Do you see an error message first?Maybe this query was too much for the backend?? > 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? > Yeah, we run into this all the time. Even though you give Access the unique identifier, it still uses all the values to ensure that only the record you are trying to update is changed, and it can detect interference from other users. Byron ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-05-27 13:07 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1998-05-27 12:43 Problems with Update in Access, ODBC Elmar Schalueck <Elmar.Schalueck@ruhr-uni-bochum.de> 1998-05-27 13:07 Re: Problems with Update in Access, ODBC Byron Nikolaidis <byronn@insightdist.com>
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