Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Using the Check Error feature with Local NAV Database Connections

This information applies to Dynamics NAV 2009R2 and earlier

Overview

If you attempt to use more than one local database connection in a workbook, you will see #VALUE for the results of one of them. When you use Check Error , the function may calculate correctly.  This is because when you run Check Error, Jet closes all other local database connections to analyze the cell you have selected.  The #VALUE occurs because each workbook can only have a single local database connection open at a time, so you can only include data from a single local database in a workbook.  You can include data from multiple server database connections on the same workbook with no problems.

Published:

Using the Check Error feature with Local NAV Database Connections

This information applies to Dynamics NAV 2009R2 and earlier

Overview

If you attempt to use more than one local database connection in a workbook, you will see #VALUE for the results of one of them. When you use Check Error , the function may calculate correctly.  This is because when you run Check Error, Jet closes all other local database connections to analyze the cell you have selected.  The #VALUE occurs because each workbook can only have a single local database connection open at a time, so you can only include data from a single local database in a workbook.  You can include data from multiple server database connections on the same workbook with no problems.

For an optimal Community experience, Please view on Desktop