Received: from smtp.interlog.com (root@smtp.interlog.com [207.34.202.37]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA85409 for ; Thu, 3 Feb 2000 11:15:22 -0500 (EST) (envelope-from cj@interlog.com) Received: from crjnt2 (cj.interlog.com [199.212.157.174]) by smtp.interlog.com (8.9.1/8.9.1) with SMTP id LAA00545 for ; Thu, 3 Feb 2000 11:15:19 -0500 (EST) Message-Id: <3.0.32.20000203111652.00a16290@mail.interlog.com> X-Sender: cj@mail.interlog.com X-Mailer: Windows Eudora Pro Version 3.0 (32) Date: Thu, 03 Feb 2000 11:16:56 -0500 To: From: "Christopher R. Jones" Subject: RE: [INTERFACES] Access 2000 and ODBC Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id LAA85434 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