Received: from smtp.screaming.net (smtp.screaming.net [212.49.224.20])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAAI5ks38206
	for <pgsql-interfaces@postgresql.org>;
	Fri, 10 Nov 2000 13:05:50 -0500 (EST)
	(envelope-from jamie@sagaxis.co.uk)
Received: from mypc.sagaxis.co.uk (dyn206-ras49.screaming.net
	[212.188.144.206])
	by smtp.screaming.net (8.9.3/8.9.3) with ESMTP id SAA22190
	for <pgsql-interfaces@postgresql.org>; Fri, 10 Nov 2000 18:08:37 GMT
Message-ID: <ZT4ztUAt3CD6EwL9@sagaxis.co.uk>
Date: Fri, 10 Nov 2000 17:18:37 +0000
To: pgsql-interfaces@postgresql.org
From: Jamie Walker <jamie@sagaxis.co.uk>
Subject: Re: Access 2000 and empty fields
References: <8568FC767B4AD311AC33006097BCD3D61A2727@woody.vale-housing.co.uk>
	<Pine.SGI.3.96.1001110090630.11023994A-100000@mole.bio.cam.ac.uk>
In-Reply-To: <Pine.SGI.3.96.1001110090630.11023994A-100000@mole.bio.cam.ac.uk>
MIME-Version: 1.0
X-Mailer: Turnpike Integrated Version 5.01 U <Ju6ZENfy+gn5ONsFep+ydlz6YF>
X-Archive-Number: 200011/120
X-Sequence-Number: 156

In article <Pine.SGI.3.96.1001110090630.11023994A-
100000@mole.bio.cam.ac.uk>, Phil Davey <pd213@mole.bio.cam.ac.uk> writes
>So, I have now tried Access SR1A with MDAC 2.5SP1 and that doesn't work.
>I can still edit fields of rows which contain no blank fields, but if
>there is a field which is blank, it won't let me edit any of that row.
Have you tried turning 'Row Versioning' on in the ODBC advanced
properties and re-linking your tables?
-- 
Jamie Walker              "While there are no known bugs in it, it might 
jamie@sagaxis.co.uk        destroy your filesystems, eat your data and
http://www.sagaxis.co.uk/  start World War III. You have been warned."