Error in Navision when changing from Native to SQL

elwin68

Our customer is working in Navision 3.70b with a native database.
A fbk is made and this is restored this in a SQL environment.
Navision is started in the SQL environment to test the application.
A lot of functionality is working fine but when changing the shipment date on a order line the following error occures: No permissions to read table Base Calender Change.

In the native database everything works fine.
I think it has to do with the license file.

Does anyone knows if this problem can be fixed without a upgrade to Navision 4 or 5.

Thanks in advance.

jlandeen

Do you have a developer or partner license?

One thing to check is if there are any values in the Base Calendar Change table. If you're not licensed to use that table or the granule that uses it then the table must be empty. To get around similar problems in the past it was just a matter of deleting all the records and restarting the Navision client.

elwin68

Thanks for your answer.

The problem was that records exist in table 'Base Calendar Change'.
Now I have deleted them and everything works fine.

jlandeen

Glad to hear that fixed everything for you.

I even know some NSC's that clear those unlicensed tables as part of go live.