I've installed the latest MDAC and Jet service packs on Windows 2000. On Linux I've the latest MySQL and MyODBC3.51.
Using the ODBC Administrator I've set up a connection and made sure to check "Don't Optimize columns width", "Return Matching Rows", "Allow BIG Results", "Use Compressed Protocol", "Change BIGINT to INT".
I ran the test and all appears well. I then link to the MySQL tables from Access and again all appears well. Until I open the table and see that all data is marked "#DELETED".
Its worth noting that the MySQL connector's help file is missing. when things go wrong, that kind of thing is a frustration.
To test, I run a few queries which should bring back one record. They all work.
So Access sees the data but cannot display it. The table does have a primary key and timestamp - its SQL follows:
CREATE TABLE `tblContacts` (
`p_ID` bigint(11) NOT NULL auto_increment,
`p_Company` int(11) default '2',
`p_FirstName` varchar(255) default NULL,
`p_LastName` varchar(255) default NULL,
`p_JobTitle` varchar(255) default NULL,
`p_DirectLine` varchar(255) default NULL,
`p_Mobile` varchar(255) default NULL,
`p_HomeNumber` varchar(255) default NULL,
`p_WorkEmail` varchar(255) default NULL,
`p_PrivateEmail` varchar(255) default NULL,
`p_Notes` varchar(255) default NULL,
`p_CandidateCV` mediumblob NOT NULL,
`p_EHR_CV` mediumblob NOT NULL,
`p_Grouping` enum('None','Manager','Developer','Producer') NOT NULL default 'Developer',
`p_CoreSkill` enum('None','C++','C#') NOT NULL default 'C++',
`c_timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`p_ID`)
) TYPE=MyISAM AUTO_INCREMENT=60 ;
Can anyone suggest why Access is not displaying the data correctly?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
