AnsweredAssumed Answered

MS Access through ODBC - you can write but you cannot read

Question asked by janfm on Feb 27, 2014
Latest reply on Mar 5, 2014 by ranja

Title

MS Access through ODBC - you can write but you cannot read

Post

     Hi,

      

     Now I know that there's been a lot of discussion about FM not supporting some ODBC sources and MS Access is not one of them, but I have a question which answer I couldn't find...

      

     After setting up System DSN for particular MS Access file on Windows7x64 FM detects that DSN in External Data Source and there is no problem importing that file, so I guess it can READ data. When 'Execute SQL' script step is used to send SQL query like UPDATE and INSERT INTO that MS Access file it works also, you can see when you open file that data has been written, so I guess it can WRITE data.

     Now, what I cannot understand. If you want use SELECT in query you have to use it in 'ExecuteSQL' function, and to refer to table that you want to read from you have to have that table in relationships graph, but of course if you try to add you'll get 'The ODBC data source you have selected is not supported."

      

     Like title said - FM can write to external data source but it cannot read from.

     I would say that this is like Beethoven's situation - He can compose, but he cannot hear :)

Outcomes