Sage 100

Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back. Open Excel, select "File" from the toolbar, then "Options…

Has anyone else had issues with MS365 Access crashing when trying to connect to Sage 100 2022 via ODBC 32 bit connection? We just upgraded, and now when I try to connect the program (Access) crashes and closes. The same version of access will still connect…

I have an excel spreadsheet that uses the SOTAMAS90 ODBC 64 Bit System DSN to update some data from our AP tables. When I open this spreadsheet on the server with Sage 100 advanced installed the query completes and data is updated is less than 5 seconds…

I have seen some similar threads but none of them seem to work. Here is my situation, and bear with me I am very green with ODBC connections: I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…

We use ODBC to connect to MS Access for several custom reports we use. After upgrading from Sage 100 Standard ver 2015 to 2017, ODBC connects to most files. However, when we try to connect to the AR Invoice History Header file it will display data correctly…

We just installed MAS 200 v4.5 on a new server and will migrating to it very soon. I wrote a custom API to expose MAS data as XML through a web site. The server that it is installed on is running Windows Server 2008 R2 64bit. I installed the MAS…