Sage 100

Client uses Access for queries. Have upgraded to 2018 and 64 bit, so error could be in either place. The cannot choose a vXXXXX file anymore from the list of files when connecting to ODBC - says something about Not On Local Machine. He can choose a ""real"" file.

I recently ran into the same thing. This is the response I got from Sage ""The 64bit driver won't work with the view tables because they're 32bit. If they are on Advanced they will be able to use the 64bit ODBC driver if they turn on Client Server ODBC driver

Well, bless your heart, in the good way, @MaryJoKrueger ! THANK YOU!

Hmm could there be confusion in that _Sage_ advice? The ""View tables"" have nothing to do with 32/64 bit as they are an extension of the dictionary. Maybe I'm the one who's confused but I would've answered like this: It sounds like on the 64-Bit ODBC administrator (not the 32-bit one), on the SOTAMAS90 DSN, the _Path to Views DLL_ is blank or invalid. Once that's set recreate the Linked Table in Access for the SELECT queries. But if client is using PTQs instead, then edit the ODBC connection string so it includes this clause: _ViewDLL=<path to \HOME>;_ Don't actually include the < > symbols. Do whatever works.

Confusion in Sage advice? Of course that's not the problem.