Hi all,
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".
<snipped>
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,
<snipped>
That's your problem there. You can't have a bigint() column as a primary key when Access is being used. In fact you probably shouldn't have any bigints at all if you're using Access. Try mediumint unsigned.
Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
