• How can I store MAS authentication in an Excel ODBC link?

    I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel…
  • Datetime fields ALL no longer allow nulls

    We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…