Solved

MySQL ODBC not returning all tables to MS Access

Posted on 2014-07-24
4
739 Views
Last Modified: 2014-07-24
I have a mysql database that will not return a handful of tables to MS Access via ODBC. I have never encountered this before. I can see no difference between the tables that show and those that don't. As well, no new tables that I create show up. What could be going on here?
0
Comment
Question by:JP_TechGroup
  • 2
4 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 40216878
the first thing that comes to my mind is that the ms access is NOT connected to the same MySQL db than the one you are looking in ...
0
 
LVL 109

Accepted Solution

by:
Ray Paseur earned 250 total points
ID: 40216888
no new tables that I create show up
This phenomenon is sometimes a symptom of testing the wrong thing.  A similar symptom is "I changed the program but I get the same result" and we find that the changes went into "directory A" but the tests were made using "directory B."  I would look closely at connection and selection processes to be sure the newly created tables are in the correct data base.
0
 

Author Closing Comment

by:JP_TechGroup
ID: 40217036
Hoo boy has it been a long week! Connected to the old dbase server which just happened to have an old copy of the dbase.
Thank you gents!
0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40217065
Done that a few times myself!  By now it's a familiar symptom.  Thanks for the points and thanks for using E-E, ~Ray
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

856 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