From: Christopher R. Jones <cj@interlog.com>
To: Phil Davey <pd213@mole.bio.cam.ac.uk>
To: pgsql-interfaces@postgresql.org
Subject: Re: Access 2000 and empty fields
Date: Tue, 07 Nov 2000 09:47:35 -0500
Message-ID: <4.3.1.2.20001107094648.00c33280@mail.interlog.com> (raw)
In-Reply-To: <Pine.SGI.3.96.1001107114710.10434560B-100000@mole.bio.cam. ac.uk>
References: <01ec01c048a8$6404ddc0$0e0210ac@fabiosis>
The same question comes up in the MySQL email list. Apparently if you get the service pack for Office 2000 and the latest MDAC from the microsoft website, this problem is fixed.
>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@pod-designs.net ICQ 46295740
>Just because you're smart, doesn't mean you can't act stupid....
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@interlog.com
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: cj@interlog.com, pd213@mole.bio.cam.ac.uk
Subject: Re: Access 2000 and empty fields
In-Reply-To: <4.3.1.2.20001107094648.00c33280@mail.interlog.com>
* 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