MySQL Forums
Forum List  »  Microsoft Access

Re: Still problem linked table in MS Access: fields are #Deleted
Posted by: Grace Coronado
Date: February 06, 2006 10:24PM

We have just migrated our data from MS Access to MySQL. But we still want to maintain the existing entry forms in MS Access.

Here’s our current settings:

Windows XP 5.1
MS Access 2002
MySQL Server 5.0.18
MyODBC 3.51.12
MS Jet Engine 4.0

We were able to view the data (all records in all tables) using Navicat and MySQL Admin without any problem. TIMESTAMP fields were added to those tables using AUTOINCR. Then, we linked the MySQL tables to MSAccess. But we are wondering why some records still display #Deleted and some are not for the same table when viewed in MS Access. Some tables only encounter this problem, others don’t.

Here is the result of the SHOW CREATE TABLE for one of the tables concerned:

CREATE TABLE `larvalswimspeed`
( `autoctr` int(11) NOT NULL auto_increment,
`StockCode` int(11) NOT NULL,
`SpecCode` int(11) default NULL,
`SpeedRefNo` int(11) NOT NULL,
`C_Code` varchar(4) default NULL,
`Larvallocality` varchar(200) default NULL,
`Length` float NOT NULL default '0',
`LengthType` varchar(3) default NULL,
`SpeedLS` float NOT NULL default '0',
`LengthTypeSpeed` varchar(5) default NULL,
`Speedms` float default NULL,
`Mode` varchar(9) default NULL,
`DataRef` int(11) default NULL,
`Reliable` varchar(50) default NULL,
`Comment` varchar(64) default NULL,
`Entered` smallint(6) NOT NULL,
`DateEntered` date default NULL,
`Modified` smallint(6) default NULL,
`DateModified` date default NULL,
`Expert` smallint(6) default NULL,
`DateChecked` char(19) default NULL,
`SLa` float default '0',
`SLb` float default '0',
`TS` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`StockCode`,`Length`,`SpeedLS`),
KEY `C_Code` (`C_Code`),
KEY `SpecCode` (`SpecCode`),
KEY `autoctr` (`autoctr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 4096 kB; InnoDB free: 4096 kB'


No BIGINT is being used. We have tried to declare TIMESTAMP fields to NOT NULL and NULL. But still #Deleted is shown.

Hope someone can enlighten us on this.

Thanks,
Grace

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.