Solved

MS Access/MySQL linked tables all fields display #Deleted but source tables are ok

Posted on 2013-10-30
4
2,229 Views
Last Modified: 2013-11-13
(Note that this had been working until hardware replacement.)
ms access query with 2 linked tables shows all of the fields as #deleted. When I open one table everything is #Deleted, the other table is ok. the odbc driver is mysql 3.51. When I look at source mysql table it appears to be fine, fully populated.

I can't seem to clear #Deleted. If I import the table vs link, everything is ok, however this method gives me other issues.
0
Comment
Question by:jsgould
  • 2
4 Comments
 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 100 total points
ID: 39612544
Try deleting and recreating the links.
0
 

Author Comment

by:jsgould
ID: 39612578
I've tried most of the typical solutions to no avail
delete/recreate links
create a new, empty access db and link these tables

because an import is fine but a link is not should be some kind of clue.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 400 total points
ID: 39612620
There's nothing wrong per say, it's just the way it works and the fact that JET uses a keyset cursor to keep track of things.

You can read about it here:

"#Deleted" errors with linked ODBC tables
http://support.microsoft.com/kb/128809

I'm afraid however I don't know much about mySQL.  If it was SQL Server, I'd tell you to add a timestamp column to the table, which turns on row versioning in SQL.  JET latches onto that and can then tell easily if a record has changed or not.

But if you read through that article, there's are some do's and don'ts which may prove helpful.

Jim.
0
 

Author Closing Comment

by:jsgould
ID: 39645715
Thank you
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now