Edward Maas wrote: > "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.
No kidding. Looking into my crystal ball, I can see that it's either one of your fields, or another, or possibly yet another, however I'm pretty sure we can rule out this last point - it's a long shot. > 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. My prediction remains as above, with the exception that it's more likely to be one of your fields. There is some documentation on connecting Access to MySQL at http://dev.mysql.com/doc/mysql/en/msaccess.html I would start there. If this doesn't work, try posting with some actual details. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
