RE: problems adding records to mysql db using odbc/access 2000

2002-09-02 Thread Henk Huizinga
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

problems adding records to mysql db using odbc/access 2000

2002-09-02 Thread Dean Browett
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