Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
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…
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

789 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