Problem deleting a linked table

davmac1

I defined a view which I repeated for each company in my database. Then I defined it as a linked table in NAV 5.0SP1.
Now I need to delete the NAV table definition, but it won't let me. I get a SQL server error - invalid object name $ndo$usrproperty.

SQL:
Select [sid] FROM [$ndo$usrproperty]

Do I need to delete the views first or is NAV just hopelessly confused?

davmac1

Here is the actual error message from NAV

bbrown

viewtopic.php?f=33&t=28551&hilit=%24ndo%24usrproperty

davmac1

Thanks - I had just googled the exact table name and found the solution you pointed me to, and tried it and it solved the problem.

It looks like Navision never updated the internal code for deleting linked objects.
I hope someone in development sees this and fixes the problem if it is not in a hotfix already.