When I have seen this error it was caused by a field defined in the MySQL database as NOT NULL in the Create table and the value in Access is NULL or usually for us an empty field in EXCEL which is appears to be intreped as NULL when you do a PASTE APPEND.
Ours is often times a datetime field but I don't think its limited to data time fields defined as NOT NULL. I have not really found an easy wasy to find the offending field except by process of elimination. Hope this helps. -----Original Message----- From: Edward Maas [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 10:31 PM To: mysql@lists.mysql.com Subject: Intersting MySQL / Access Issue Dear Community, My team and I have been experiencing an interesting mysql error during the past few weeks of testing. Here is the scenario we are trying to accomplish. We are essentially working to use MsAccess as a windows client for a linux based mysql databases. We have installed myODBC 3.51 and are using that for communication. We seem to be able to create a linked table just find and select queries work great. The problem arises when we try to update or insert data. Updates yield the following error: "You Tried to assign the Null value to a variable that is not a Variant data type." From my searching, I was unable to find how to set fields to variant data types. Secondly, I am not sure which field is causing the error. The second issue was with inserts. On insert of just one field (none are required other than the primary key), ALL of the fields of type text are set to NULL. This is particularly odd and occurs also in the mysql command line utilty. If anyone has any ideas or experience, please send emails to [EMAIL PROTECTED] We will definitely summarize the solution for the educaitonal purposes of the list. Again many thanks in advance. Sincerely,, Ed Maas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
