Access 2000 and empty fields

From: Phil Davey <pd213(at)mole(dot)bio(dot)cam(dot)ac(dot)uk>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Access 2000 and empty fields
Date: 2000-11-07 11:55:12
Message-ID: Pine.SGI.3.96.1001107114710.10434560B-100000@mole.bio.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


I'm having problems using Access 2000 and Postgresql.
I am linking tables using the ODBC driver.

In Access's table view, you can update fields of rows which contain no
empty fields fine.

However, if any of the rows fields are empty, it won't let you change it
at all.
message box title: "Write Conflict"
description: "This record has been changed by another user since you
started editing it. If you save the record, you will overwrite
the changes the other user made."
buttons: "Copy to Clipboard" and "Drop Changes".

I've been told, although I haven't tried it myself, that Access 97 works
ok.

Is this a problem with Access 2000, the ODBC driver or Postgresql itself,
and is there any way of fixing/working around this problem?

--
Phil Davey
http://www.pod-designs.net/philandjo.html
E-mail pod(at)pod-designs(dot)net ICQ 46295740
Just because you're smart, doesn't mean you can't act stupid....

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tim Kane 2000-11-07 12:37:00 PgAdmin exporter DLL's
Previous Message Enrico Mangano 2000-11-07 10:49:23 comunication between dbs