3305 Main Street Ste 019 Vancouver, WA 98663

Why doesn't my Office Connector report work after upgrading Sage 300 Construction and Real Estate?

Background

An Office Connector report consists of queries and functions that refer to specific tables and columns in your Sage 300 Construction and Real Estate database. Although it is very uncommon, a new version of Sage 300 Construction and Real Estate may include changes to the database that result in certain tables or columns being retired. If a table or column no longer exists in the database and your report design references the removed item, all or part of your report may not function.

Symptoms

Your report may have been affected by a database change if you encounter the following message when trying to run the report after upgrading:

One of your queries could not be refreshed. If you have changed data folders since the query was created, it is possible that the current data folder does not contain the required data.
Do you want to skip recalculating the workbook formulas?

In addition, formulas containing Office Connector functions may return error messages such as:

#TABLE

In the case of a query that can't be refreshed, you can obtain additional details about the problem by right-clicking within the range of cells where the query is located and then click Refresh. The error message that is displayed in this case may reveal additional information about specific tables or columns that are the problem. Example-

[Simba][SimbaEngine ODBC Driver]Invalid column name: 'SINSCR'.

Resolution

The resolution to the issue will be dependent on the specific database change that was made. The resolution could consist of removing the reference to the item or replacing it with a different table or column. The specific course of action will best be determined by the author of the report or a qualified Office Connector consultant.

See also