pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedAccess 2000 and ODBC
6+ messages / 5 participants
[nested] [flat]
* Access 2000 and ODBC
@ 2000-02-03 12:57 Paul Rijke <p.rijke@truckland.nl>
0 siblings, 0 replies; 6+ messages in thread
From: Paul Rijke @ 2000-02-03 12:57 UTC (permalink / raw)
To: pgsql-interfaces
Is there already a solution to the linking of tables in Access 2000?
Paul Rijke
Truckland B.V.
Basisweg 47
1043 AN AMSTERDAM
tel: 020 - 585 1234
fax: 020 - 585 1189
e-mail: p.rijke@truckland.nl *
website: http://www.truckland.nl *
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] Access 2000 and ODBC
@ 2000-02-03 14:05 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 6+ messages in thread
From: Nicolas Huillard @ 2000-02-03 14:05 UTC (permalink / raw)
To: 'p.rijke@truckland.nl' <p.rijke@truckland.nl>; pgsql-interfaces
Can you explain a little bit more what you want ?
Nicolas Huillard
-----Message d'origine-----
De: Paul Rijke [SMTP:p.rijke@truckland.nl]
Date: jeudi 3 février 2000 13:58
À: pgsql-interfaces@postgreSQL.org
Objet: [INTERFACES] Access 2000 and ODBC
Is there already a solution to the linking of tables in Access 2000?
Paul Rijke
Truckland B.V.
Basisweg 47
1043 AN AMSTERDAM
tel: 020 - 585 1234
fax: 020 - 585 1189
e-mail: p.rijke@truckland.nl *
website: http://www.truckland.nl *
************
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] Access 2000 and ODBC
@ 2000-02-03 14:44 Nicolas Huillard <nhuillard@ghs.fr>
0 siblings, 0 replies; 6+ messages in thread
From: Nicolas Huillard @ 2000-02-03 14:44 UTC (permalink / raw)
To: 'p.rijke@truckland.nl' <p.rijke@truckland.nl>; pgsql-interfaces
Since I haven't got any answer, I transfer this mail to the list...
Nicolas Huillard
-----Message d'origine-----
De: Paul Rijke [SMTP:p.rijke@truckland.nl]
Date: jeudi 3 février 2000 15:08
À: Nicolas Huillard
Objet: RE: [INTERFACES] Access 2000 and ODBC
Yes of course.... There seems to be a problem linking tables from Postgres
into Access 2000. In Access 97 there's not a
problem at all, but in 2000 the tables are read only, no matter what the
ODBC driveroptions are....
It looks like a bug and looking trough the archives a lot of people are
confronted with the same problem...
I was curious if someone has tackled the problem yet...
-----Oorspronkelijk bericht-----
Van: Nicolas Huillard [mailto:nhuillard@ghs.fr]
Verzonden: donderdag 3 februari 2000 15:06
Aan: 'p.rijke@truckland.nl';
Onderwerp: RE: [INTERFACES] Access 2000 and ODBC
Can you explain a little bit more what you want ?
Nicolas Huillard
-----Message d'origine-----
De: Paul Rijke [SMTP:p.rijke@truckland.nl]
Date: jeudi 3 février 2000 13:58
À: pgsql-interfaces@postgreSQL.org
Objet: [INTERFACES] Access 2000 and ODBC
Is there already a solution to the linking of tables in Access 2000?
Paul Rijke
Truckland B.V.
Basisweg 47
1043 AN AMSTERDAM
tel: 020 - 585 1234
fax: 020 - 585 1189
e-mail: p.rijke@truckland.nl *
website: http://www.truckland.nl *
************
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] Access 2000 and ODBC
@ 2000-02-03 16:16 Christopher R. Jones <cj@interlog.com>
2000-02-03 16:47 ` Re: [INTERFACES] Access 2000 and ODBC Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 6+ messages in thread
From: Christopher R. Jones @ 2000-02-03 16:16 UTC (permalink / raw)
To: pgsql-interfaces
Interestingly enough, this thread is also very active on the MySQL mailing
list. It seems that ACCESS 2000 has a bug that makes many ODBC datasources
read only. Some MySQL tables linked to Access 2000 via ODBC are read/write
and some are not. Note that if the tables are converted to Foxpro tables
(use same column types) then Access has no problem. Hopefully Microsoft
will pay attention.
>Since I haven't got any answer, I transfer this mail to the list...
>
>Nicolas Huillard
>
>-----Message d'origine-----
>De: Paul Rijke [SMTP:p.rijke@truckland.nl]
>Date: jeudi 3 février 2000 15:08
>À: Nicolas Huillard
>Objet: RE: [INTERFACES] Access 2000 and ODBC
>
>Yes of course.... There seems to be a problem linking tables from Postgres
>into Access 2000. In Access 97 there's not a
>problem at all, but in 2000 the tables are read only, no matter what the
>ODBC driveroptions are....
>
>It looks like a bug and looking trough the archives a lot of people are
>confronted with the same problem...
>
>I was curious if someone has tackled the problem yet...
>
>-----Oorspronkelijk bericht-----
>Van: Nicolas Huillard [mailto:nhuillard@ghs.fr]
>Verzonden: donderdag 3 februari 2000 15:06
>Aan: 'p.rijke@truckland.nl';
>Onderwerp: RE: [INTERFACES] Access 2000 and ODBC
>
>
>Can you explain a little bit more what you want ?
>
>Nicolas Huillard
>
>-----Message d'origine-----
>De: Paul Rijke [SMTP:p.rijke@truckland.nl]
>Date: jeudi 3 février 2000 13:58
>À: pgsql-interfaces@postgreSQL.org
>Objet: [INTERFACES] Access 2000 and ODBC
>
>Is there already a solution to the linking of tables in Access 2000?
>
>Paul Rijke
>Truckland B.V.
>Basisweg 47
>1043 AN AMSTERDAM
>tel: 020 - 585 1234
>fax: 020 - 585 1189
>e-mail: p.rijke@truckland.nl *
>website: http://www.truckland.nl *
>
>
>
>************
>
>
>************
>
>
>
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] 6+ messages in thread
* Re: [INTERFACES] Access 2000 and ODBC
2000-02-03 16:16 RE: [INTERFACES] Access 2000 and ODBC Christopher R. Jones <cj@interlog.com>
@ 2000-02-03 16:47 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 0 replies; 6+ messages in thread
From: Thomas Lockhart @ 2000-02-03 16:47 UTC (permalink / raw)
To: Christopher R. Jones <cj@interlog.com>; +Cc: pgsql-interfaces
> Interestingly enough, this thread is also very active on the MySQL mailing
> list. It seems that ACCESS 2000 has a bug that makes many ODBC datasources
> read only. Some MySQL tables linked to Access 2000 via ODBC are read/write
> and some are not. Note that if the tables are converted to Foxpro tables
> (use same column types) then Access has no problem. Hopefully Microsoft
> will pay attention.
I've worked just a bit with ODBC, but not with any of the front end
tools you are discussing. But I vaguely recall some discussion on the
list that some tool (Access?) required that there be a primary key
defined to allow a table to be considered writable.
Does this ring a bell with anyone? If not, sorry for the
misdirection...
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: [INTERFACES] Access 2000 and ODBC
@ 2000-02-03 16:59 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 6+ messages in thread
From: Peter Mount @ 2000-02-03 16:59 UTC (permalink / raw)
To: 'Thomas Lockhart' <lockhart@alumni.caltech.edu>; Christopher R. Jones <cj@interlog.com>; +Cc: pgsql-interfaces
I haven't used Access with the ODBC driver (only Crystal Reports), but I
do remember this requirement.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: Thomas Lockhart [mailto:lockhart@alumni.caltech.edu]
Sent: Thursday, February 03, 2000 4:48 PM
To: Christopher R. Jones
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Access 2000 and ODBC
> Interestingly enough, this thread is also very active on the MySQL
mailing
> list. It seems that ACCESS 2000 has a bug that makes many ODBC
datasources
> read only. Some MySQL tables linked to Access 2000 via ODBC are
read/write
> and some are not. Note that if the tables are converted to Foxpro
tables
> (use same column types) then Access has no problem. Hopefully
Microsoft
> will pay attention.
I've worked just a bit with ODBC, but not with any of the front end
tools you are discussing. But I vaguely recall some discussion on the
list that some tool (Access?) required that there be a primary key
defined to allow a table to be considered writable.
Does this ring a bell with anyone? If not, sorry for the
misdirection...
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
************
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2000-02-03 16:59 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-03 12:57 Access 2000 and ODBC Paul Rijke <p.rijke@truckland.nl>
2000-02-03 14:05 RE: [INTERFACES] Access 2000 and ODBC Nicolas Huillard <nhuillard@ghs.fr>
2000-02-03 14:44 RE: [INTERFACES] Access 2000 and ODBC Nicolas Huillard <nhuillard@ghs.fr>
2000-02-03 16:16 RE: [INTERFACES] Access 2000 and ODBC Christopher R. Jones <cj@interlog.com>
2000-02-03 16:47 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-02-03 16:59 RE: [INTERFACES] Access 2000 and ODBC Peter Mount <petermount@it.maidstone.gov.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