I am facing difficulties in adding new column in my Resource ledger entry table. I tried to go "Object Designer --> Table" ,click on "design" and add new field named "TaskA,TaskB,TaskC,TaskD", 4 new field and defined the datatype. after that, i click on "Compile".... but just few minutes my navision will closed and when i log in again, i cant even access to my Resource Ledger Entry table. Shows not able to access the table's error. Luckily i try this at testing server.......The table contains 984,299 line of data. Any Idea on why it happened and how to "backup" the table first, and restore it (include the data) when it corrupted while compile in progress?
Have a great day, Erik
In reply to sbhatbng:
In reply to Erik P. Ernst:
In reply to jliang84:
yes, confirmed is 4.0 sp2. I am running the navision on windows server 2003, connect the client thru citrix.
Yeap, upgrade is not an option for me... too many customization table inside and the database file is too big for me to do the backup. it is over 150GB ... i am headache on this issue also.... I am worried because i need to applied the changes to my production server.....