Browse By Tags

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…

This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…

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…

ODBC Driver error in Power Query "Unexpected error: Attempted to read or write protected memory..." We are using the Sage 50 v25 32b ODBC driver. The underlying query is "select * from ACCOUNT_STATUS" or specifically when querying date time (tz sensitive…

I try to connect MS Excel to Sage file via ODBC. I got following message: Details: "ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)" I am using Windows 10 64-bit. MS…

I have some macro code that is printing A/R Invoices to PDF files. The code works fine on my laptop, but on the client workstation, it crashes. Event Viewer identifies MSVCR120.DLL as the problem. The OS and Excel versions are identical on the workstation…

How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…

I´m using ConnectionManagerService.dll and I am using the function wSDBSelectRecords with this syntax: Call wSDBSelectRecords(iDBLink, iTBLink, "", 0, True) But I do not know how to capture the data you are going to select in a DataTable. I´m Working…