Sage 100

 View Only

  • 1.  I have an issue with creating an MS Query using th

    Posted 01-28-2016 12:44
    I have an issue with creating an MS Query using the 64-bit ODBC driver and 64-bit Excel. I am trying to add the vSalespersonCommission view to the query and it shows the name of the view but no fields underneath it. Anyone else seen this type of behavior. Sage 100 advanced 2014 (5.10.1.0).


  • 2.  RE: I have an issue with creating an MS Query using th

    Posted 01-28-2016 14:06
    I'm with you as I can't seem to access any of the views (normal tables are fine). Tried Excel 2016 64-bit to 64-bit SOTAMAS90. Works with Excel 2016 32-bit. 5.10.4.0


  • 3.  RE: I have an issue with creating an MS Query using th

    Posted 01-28-2016 20:31
    Any chance in your 64-bit DSN on the Options tab the _Path to Views DLL_ is blank or doesn't point to \mas90\Home ?


  • 4.  RE: I have an issue with creating an MS Query using th

    Posted 01-29-2016 05:05
    My Path to Views DLL is pointing to MAS90\Home.


  • 5.  RE: I have an issue with creating an MS Query using th

    Posted 01-29-2016 05:25
    My path is also pointing to the MAS90\Home directory


  • 6.  RE: I have an issue with creating an MS Query using th

    Posted 01-29-2016 07:37
    Never could get that 64 bit driver to work. I just use the 32 bit driver.


Related Content