Strange errors when I try to access my MS Access DB via MATLAB "dexplore"

1 view (last 30 days)
I have some strange errors when I try to access my MS Access DB via MATLAB.
Some hints:
  • The data preview to the tutorial.mdb (shipped with MATLAB) works very well via dexplore - I can see all the tables and I can import the data.
  • The data preview to my own DB works on another system where e.g the language settings differ. -> screenshot 1 This is how the DB preview looks on the other system. Note that table and column names are framed with the ` character. At first the preview resulted in an error too for one of the tables (0433_Slices) - when I renamed it by framing the name with the ' character inside MS Access, I could enforce the table name to be recognized as a string in MATLAB and now this table is importable too.
  • In my system, the preview does not work and gives error messages like "Syntax error in query message" or "Syntax error in FROM clause" "Incomplete query clause" -> screenshot 2 You see here one of the possible error messages, and that neither table nor column names are framed with the ` character. I tried to enforce the recognition of table names by using " characters or ' characters, but that did not work!
Comparing my system to the other system, the most prominent difference is that table names and column names are not recognized as strings (= they are framed with ' characters), and I think this results in the mentioned error messages. Can I fix this somehow, or am I totally on the wrong track?
Thanks for your help!
  1 Comment
Kallam Haranadha Reddy
Kallam Haranadha Reddy on 15 Aug 2016
I too am getting the same problem when i want to change from one table to the other table in the same database. I am using the MS - Access database. I am getting the error messages Invalid cursor and syntax error in FROM clause. The first query is working well ( giving the result) in the first table. But when the second and third queries are run from second and third tables it is giving the above error. May i know, how you fixed this error.

Sign in to comment.

Answers (0)

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!