List:MySQL ODBC« Previous MessageNext Message »
From:Ron Alexander Date:February 3 2006 8:01pm
Subject:RE: #deleted in Access
View as plain text  
MySQL table that are linked in Access must have two thing in every
single liked table. Those two items are a TIMESTAMP column and a Primary
key (PK). 

I had this issue a few years ago when I first set up Access with linked
table to MySQL.

-----Original Message-----
From: Martin King-Turner [mailto:martin.kt@stripped] 
Sent: Friday, February 03, 2006 2:55 PM
To: 'Rigov'
Cc: 'Martin J. Evans'; myodbc@stripped
Subject: RE: #deleted in Access

I have found that adding a TIMESTAMP column to the table in MySQL solves
most #deleted problems with MyODBC and Access.  Take a look at  When
added the timestamp column, remember to refresh the table definition in
Access so that Access can see the additional column.

Martin King-Turner
-----Original Message-----
From: Martin J. Evans [mailto:martin.evans@stripped] 
Sent: 03 February 2006 18:06
To: myodbc@stripped
Subject: RE: #deleted in Access

I'm not sure about MyODBC but from memory this occurs in Access because
attempts to retrieve a row with the primary key value (it previously
retrieved) and couldn't find the row (indicating to Access the row has

i.e. it does
select primary_key_column from table then retrieves the data with select
a,b,c,d from table where primary_key_column = ? and fails to retrieve a

In actual fact, it tends to retrieve 10 rows at a time with

select a,b,c,d from table where pcc = ? or pcc=? or pcc=? (10 of these).

Not sure if this helps you but it may give you or someone else somewhere


On 03-Feb-2006 Rigov wrote:
> 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, but to no avail.  I'm using Access
> 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`)
> Other tables have similar properties, and they do not have this 
> problem.
> This is the only InnoDB table, but even after dropping it, and
> as MyISAM, I had no luck.  Other tables have bigint() and they are
> Any help would be appreciated.
> Thanks
> _______________________________________________
> No banners. No pop-ups. No kidding.
> Make My Way  your home on the Web -
> --
> MySQL ODBC Mailing List
> For list archives:
> To unsubscribe:   

Martin J. Evans
Easysoft Ltd, UK

MySQL ODBC Mailing List
For list archives:
To unsubscribe:

MySQL ODBC Mailing List
For list archives:
To unsubscribe:

#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