ODBC Help

[Vic Spainhower]

Hello,

This is probably not the correct forum to post this problem but I posted it
in the Access group but didn't get a reply and I'd like to move forward on
this.

I have setup an ODBC Connection to a MySQL database (driver version is 3.51)
but when I setup the link in MS Access 2002 some of the tables will show
#Name? in all of the fields, some will show #Deleted in all of the fields
and some will work (except I can't update them). One of the table that I
get #Name? is only 2 columns created with the following SQL:

CREATE TABLE `login` (
`loginName` varchar(20) NOT NULL default '',
`loginTime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`loginName`,`loginTime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

On the #Name? ones I also get the message ODBC Call Failed with the
following message. The MySQL database is on my local machine which is
confusing because some of the table display the data correctly which
indicates it should not be a connection problem. I can import all of the
tables into Access but I just can't link.

ODBC - call failed. (Error 3146)
Using an ODBC connection, you tried to perform an operation on data in an
ODBC data source. This error may occur when the ODBC data source is on a
network drive and you are not connected to the network. Make sure the
network is available, and then try the operation again.

Thanks,

Vic