Access Linked Tables show #Deleted

[Thomas Bartkus]

What can I do about my Access Linked ODBC tables showing the #Deleted
error?

I am using MySQL ODBC 3.51 Driver and Access 2000.
I can create linked tables to the MySQL database running remotely on a Linux
box.
Unfortunately, when you open the table (in Access), all the data are filled
with [#Deleted] error values.

This one is driving me crazy because I can successfully read and write to
this database ODBC<->DAO or ODBC<->ADO. So the ODBC configuration has to be
substatntially correct - right?

So how do I get Access to display the data properly?
Thomas Bartkus

[Thomas Bartkus]

"Thomas Bartkus" <Th***********@Comcast.net> wrote in message
news:FL********************@telcove.net...

What can I do about my Access Linked ODBC tables showing the #Deleted
error?

I am using MySQL ODBC 3.51 Driver and Access 2000.
I can create linked tables to the MySQL database running remotely on a Linux box.
Unfortunately, when you open the table (in Access), all the data are filled with [#Deleted] error values.

This one is driving me crazy because I can successfully read and write to
this database ODBC<->DAO or ODBC<->ADO. So the ODBC configuration has to be substatntially correct - right?

So how do I get Access to display the data properly?
Thomas Bartkus

Replying to my own question -

Access can not tolerate the BIGINT type. If a primary key is type BIGINT
then we have this problem. When I converted the key to type INT the problem
went away and access can work with the MySQL table just fine.

Thomas Bartkus