Hi, Can someone tell me how I can add a record to a mysql table via an Access 2000 interface using ODBC ver 2.50.39.
The primary key on the msyql db is set to auto_increment. When I link to these tables via Access/ODBC the field type in Access is marked as a 'number' data type. Since the tables are linked I cannot change anything on the Access side of the equation. I want to add a record into the mysql table, but everytime I do this I get the following error message: "You tried to assign the Null value to a variable that isn't a Variant data type". I have defined the default value (in Access) to be 'null', but in order to do this the data type needs to be 'variant'. How can I get this field to be of 'variant' type? Any help would be appreciated TIA Dean --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php