Dean, Which MDAC version do you use with ODBC ?
Henk -----Original Message----- From: Dean Browett [mailto:[EMAIL PROTECTED]] Sent: maandag 2 september 2002 13:38 To: [EMAIL PROTECTED] Subject: problems adding records to mysql db using odbc/access 2000 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 ********************************************************************** The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. ********************************************************************** --------------------------------------------------------------------- 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
