Solved

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

Posted on 2013-10-30
4
2,255 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

770 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