List:MySQL ODBC« Previous MessageNext Message »
From:Rigov Date:February 3 2006 5:38pm
Subject:#deleted in Access
View as plain text  

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',
  `subunit`
enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23')
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.

Thanks


_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com


Thread
#deleted in AccessRigov3 Feb
  • RE: #deleted in AccessMartin J. Evans3 Feb
    • RE: #deleted in AccessMartin King-Turner3 Feb
  • RE: #deleted in AccessVic Spainhower3 Feb
RE: #deleted in AccessRon Alexander3 Feb