I have MySQL 3.21.x and MySQL Connector/ODBC 3.51 and for one of my tables, all values
show up as #Deleted. I've followed the directions found under Support on mysql.com, but
to no avail. I'm using Access 2003.
Here is a definition of the table:
CREATE TABLE `device_responses` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`time_tag` bigint(10) unsigned default NULL,
`system` enum('D') NOT NULL default 'STE',
`device` enum('A', 'B', 'C') NOT NULL default 'HEARTBEAT',
NOT NULL default '0',
`sender` enum('0','1','2','3','4','5','6','7','8') default '0',
`command` varchar(8) default NULL,
`response` varchar(8) default NULL,
PRIMARY KEY (`id`),
KEY `(command, response)` (`command`,`response`),
KEY `(response, command)` (`response`,`command`),
KEY `device` (`device`),
KEY `system` (`system`),
KEY `sender` (`sender`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
Other tables have similar properties, and they do not have this problem. This is the only
InnoDB table, but even after dropping it, and creating new as MyISAM, I had no luck.
Other tables have bigint() and they are okay.
Any help would be appreciated.
No banners. No pop-ups. No kidding.
Make My Way your home on the Web - http://www.myway.com