By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 930 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.


P: n/a

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

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`)

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.



Jul 17 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.