MySQL Forums
Forum List  »  Microsoft Access

MyODBC not creating primary keys
Posted by: Hamster
Date: May 31, 2005 04:30AM


I am using the MyODBC connecter version 3.51 on a winXP box with MS Access 2000.

I have set the connector up to talk to MySQL version 4.1.11 running on linux (debian sid).

I am attempting to export tables from an Access database into MySQL. I am doing so by choosing "export" and selecting ODBC.

The process seems to be going more or less ok. The tables are created in MySQL and populated with data. The problem is that the tables in MySQL do not have any primary keys - the primary keys are not being created. And yes, the tables in the Access database do have primary keys.

Does anyone have any idea why the primary keys are not being transfered to MySQL when the tables are being created?



Options: ReplyQuote

Written By
MyODBC not creating primary keys
May 31, 2005 04:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.