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.

>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