Hello,
I appologise if this is not the correct forum for this problem but I posted
this in the Access Group and didn't get a response. I've gotten some really
good and fast help here and I'd like to get this resolved and move forward.
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`,`l oginTime`)
) 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 am able to import the
tables, I just can't setup a 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
I appologise if this is not the correct forum for this problem but I posted
this in the Access Group and didn't get a response. I've gotten some really
good and fast help here and I'd like to get this resolved and move forward.
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`,`l oginTime`)
) 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 am able to import the
tables, I just can't setup a 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