pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess 2000 and empty fields
7+ messages / 5 participants
[nested] [flat]
* Access 2000 and empty fields
@ 2000-11-07 11:55 ` Phil Davey <pd213@mole.bio.cam.ac.uk>
1 sibling, 0 replies; 7+ messages in thread
From: Phil Davey @ 2000-11-07 11:55 UTC (permalink / raw)
To: 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@pod-designs.net ICQ 46295740
Just because you're smart, doesn't mean you can't act stupid....
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Access 2000 and empty fields
@ 2000-11-07 14:47 ` Christopher R. Jones <cj@interlog.com>
2000-11-09 12:15 ` Re: Access 2000 and empty fields Phil Davey <pd213@mole.bio.cam.ac.uk>
1 sibling, 1 reply; 7+ messages in thread
From: Christopher R. Jones @ 2000-11-07 14:47 UTC (permalink / raw)
To: Phil Davey <pd213@mole.bio.cam.ac.uk>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Access 2000 and empty fields
2000-11-07 14:47 ` Re: Access 2000 and empty fields Christopher R. Jones <cj@interlog.com>
@ 2000-11-09 12:15 ` Phil Davey <pd213@mole.bio.cam.ac.uk>
0 siblings, 0 replies; 7+ messages in thread
From: Phil Davey @ 2000-11-09 12:15 UTC (permalink / raw)
To: Christopher R. Jones <cj@interlog.com>; +Cc: pgsql-interfaces
On Tue, 7 Nov 2000, Christopher R. Jones wrote:
> 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.
Thanks for the help.
I've installed Service pack SR1A for Access and installed the (almost)
latest MDAC (2.1SP2 I think). The only more recent version is the one that
comes with Win2K and isn't downloadable yet (2.5).
None of that made any difference though - I still get exactly the same
problem.
Any other ideas?
> >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."
--
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....
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Access 2000 and empty fields
@ 2000-11-09 21:54 Dave Page <dpage@vale-housing.co.uk>
2000-11-10 09:13 ` RE: Access 2000 and empty fields Phil Davey <pd213@mole.bio.cam.ac.uk>
2000-11-10 11:12 ` RE: Access 2000 and empty fields Francis Solomon <francis@stellison.co.uk>
0 siblings, 2 replies; 7+ messages in thread
From: Dave Page @ 2000-11-09 21:54 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Phil Davey [mailto:pd213@mole.bio.cam.ac.uk]
> Sent: 09 November 2000 12:15
> To: Christopher R. Jones
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] Access 2000 and empty fields
>
>
> On Tue, 7 Nov 2000, Christopher R. Jones wrote:
> > 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.
>
> Thanks for the help.
> I've installed Service pack SR1A for Access and installed the (almost)
> latest MDAC (2.1SP2 I think). The only more recent version is
> the one that
> comes with Win2K and isn't downloadable yet (2.5).
MDAC 2.5 is downloadable from www.microsoft.com/data - in fact 2.6 is also
available there but that version no longer includes the JET engine. A KB
article (I forget the number) says you can download JET seperately but I've
been completely unable to find the download....
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Access 2000 and empty fields
2000-11-09 21:54 RE: Access 2000 and empty fields Dave Page <dpage@vale-housing.co.uk>
@ 2000-11-10 09:13 ` Phil Davey <pd213@mole.bio.cam.ac.uk>
2000-11-10 17:18 ` Re: Access 2000 and empty fields Jamie Walker <jamie@sagaxis.co.uk>
1 sibling, 1 reply; 7+ messages in thread
From: Phil Davey @ 2000-11-10 09:13 UTC (permalink / raw)
To: pgsql-interfaces
On Thu, 9 Nov 2000, Dave Page wrote:
> MDAC 2.5 is downloadable from www.microsoft.com/data - in fact 2.6 is also
> available there but that version no longer includes the JET engine. A KB
> article (I forget the number) says you can download JET seperately but I've
> been completely unable to find the download....
Oops, my mistake. I found 2.1 first, but then I found that the actual
latest version was indeed 2.5SP1. (It was 2.6 that isn't downloadable).
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.
--
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....
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Access 2000 and empty fields
2000-11-09 21:54 RE: Access 2000 and empty fields Dave Page <dpage@vale-housing.co.uk>
2000-11-10 09:13 ` RE: Access 2000 and empty fields Phil Davey <pd213@mole.bio.cam.ac.uk>
@ 2000-11-10 17:18 ` Jamie Walker <jamie@sagaxis.co.uk>
0 siblings, 0 replies; 7+ messages in thread
From: Jamie Walker @ 2000-11-10 17:18 UTC (permalink / raw)
To: pgsql-interfaces
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."
^ permalink raw reply [nested|flat] 7+ messages in thread
* RE: Access 2000 and empty fields
2000-11-09 21:54 RE: Access 2000 and empty fields Dave Page <dpage@vale-housing.co.uk>
@ 2000-11-10 11:12 ` Francis Solomon <francis@stellison.co.uk>
1 sibling, 0 replies; 7+ messages in thread
From: Francis Solomon @ 2000-11-10 11:12 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; pgsql-interfaces; pd213@mole.bio.cam.ac.uk
Dave and Phil,
Some links that might interest you ...
MDAC 2.6: http://www.microsoft.com/data/download_260rtm.htm
MDAC 2.6 Software Development Kit:
http://www.microsoft.com/data/download_260SDK.htm
JET 4.0 SP5: http://support.microsoft.com/support/kb/articles/Q239/1/14.ASP
The JET 4 page has links to three different versions: for Win9x/NT, for
Win2K, and for WinME.
Note that SP5 is brand new - less than a week old, so it may be worth
getting even for those who've downloaded it relatively recently. I couldn't
tell you what issues it fixes, though, since I only discovered the new SP
myself this morning :)
Hope these new revs might fix your problem. Enjoy.
Francis Solomon
<..snip..>
> MDAC 2.5 is downloadable from www.microsoft.com/data - in fact 2.6 is also
> available there but that version no longer includes the JET engine. A KB
> article (I forget the number) says you can download JET
> seperately but I've
> been completely unable to find the download....
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2000-11-10 17:18 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-07 11:55 ` Phil Davey <pd213@mole.bio.cam.ac.uk>
2000-11-07 14:47 ` Christopher R. Jones <cj@interlog.com>
2000-11-09 12:15 ` Phil Davey <pd213@mole.bio.cam.ac.uk>
2000-11-09 21:54 RE: Access 2000 and empty fields Dave Page <dpage@vale-housing.co.uk>
2000-11-10 09:13 ` Phil Davey <pd213@mole.bio.cam.ac.uk>
2000-11-10 17:18 ` Jamie Walker <jamie@sagaxis.co.uk>
2000-11-10 11:12 ` Francis Solomon <francis@stellison.co.uk>
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