Compiling Tables

  • Article

This topic describes requirements and restrictions for compiling a table object after you make changes to a table’s schema, such as adding or removing a table field.

When you compile a table, the validation of changes is performed by Microsoft Dynamics NAV Server. When you compile a table, you will also have to choose how to synchronize the table schema in the database. For more information about table schema synchronization, see Synchronizing Table Schemas.

If you try to compile a table object when your environment does not meet the conditions outlined in this topic, you will get the following error: The specified [service instance] can’t be reached, where [service instance] is the name of the Microsoft Dynamics NAV Server instance.

If you cannot meet the conditions for compiling tables with validation, then you have the option to compile the table object without validation.

Note

The information in this topic does not apply to C/AL code changes made to a table object. With code changes, you can compile the table object like any other object.

Conditions for Compiling Tables with Validation

To compile a table after making schema changes, your environment must meet the following conditions:

  • The development environment can connect to a running Microsoft Dynamics NAV Server instance.

  • The Microsoft Dynamics NAV Server instance is not configured for multitenancy. If it is configured for multitenancy then only a single tenant can be mounted on the server instance.

  • You can be authenticated by the Microsoft Dynamics NAV Server according to one of the following conditions:

    • You are set up as a Dynamics NAV user on your Windows account in the Dynamics NAVdatabase. This is the recommended option. For more information about setting up a user, see How to: Create Microsoft Dynamics NAV Users.

    • You are set up as an administrator on the computer that is running Microsoft Dynamics NAV Server.

      If the development environment is installed on the same computer as Microsoft Dynamics NAV Server, then you must also run the development environment as an administrator. To do this, right-click the Microsoft Dynamics NAV 2018 Development Environment link on your desktop, and then choose Run as Administrator.