From: Oliver Artelt Date: March 11 1999 10:53pm Subject: Re: MS Access & MyODBC List-Archive: http://lists.mysql.com/myodbc/13 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 11 Mar 1999, Doug Ledbetter wrote: > I've tried using MS Access 97 to link to MySQL databases on a Linux server > and limited success. > > I've had no trouble making the connection and viewing the data, but > inserting and changing data has been a problem. > > Anybody else using MS Access to connect to a MySQL DB on a Unix server? Hmh, try this: - Have these linked mysql-Tables in Access got the primary key? - Are you using 'unmatchable' field types (maybe timestamps)? Try to link a test-table with only a textfield or so. - Try the myodbc vsn 1 compatibility mode. - use an odbc-logtool to analyze the odbc-traffic oli.