471,108 Members | 1,307 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Access Linked Tables show #Deleted

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
Jul 20 '05 #1
1 4051
"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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mike Wilson | last post: by
1 post views Thread by gordon.dtr | last post: by
4 posts views Thread by Vanessa | last post: by
8 posts views Thread by rdemyan via AccessMonster.com | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.