Skip to main content

Users of Microsoft Dynamics NAV 5.0 Grapple with Approaches to Handling "Table Locking"

by Jared Berezin
Oftentimes, a problem shared among various organizations reflects a larger unmet need across a particular user group. In a NAV User Group webinar last month, "Go Live," recent adopters of Microsoft Dynamics NAV 5.0 voiced their concerns about "table locking" in NAV. Ultimately, the issue revealed the invaluable role of experienced programmers and value added resellers (VARs) in order to correctly and effectively maximize Nav 5.0.

A user in the manufacturing industry who recently adopted NAV 5.0 (running on SQL version 4), explained that his company's product orders, which come in via its website, are programmed to import directly into NAV. However, at times the program inconveniently locks when information is being manually entered into tables that are simultaneously being accessed by the import function in NAV.

Terry Murphy, a Microsoft Dynamics NAV Partner, offered a temporary fix to minimize this problem. Organizations undergoing a significant amount of ongoing transactions should schedule automated tasks during office downtime (e.g. after midnight) to avoid collision with manual processes.
However, to really tackle the nuts and bolts of the issue, Murphy recommended viewing Microsoft's papers on this topic, and enrolling in a Microsoft course that specifically addresses the issue. But who within an organization would truly benefit from such a technical NAV-specific course? Who could ensure the reliability and efficacy of NAV 5.0? Programmers and VARs, participants agreed.

User group participants agreed, though, that they would be hard pressed to find a programmer who possesses the required comprehensive, in-depth knowledge of NAV 5.0. Therefore, the search should be for a seasoned programmer who understands NAV and has the capacity to develop skills in fine-tuning the product.

In many organizations, experienced programmers are already a part of the team and may be able ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Jared Berezin
Jared Berezin serves as a contributing writer to With combined interests in technology and science, Jared previously served as a writer for Dana-Farber Cancer Institute, drafting scientific narrative reports on the latest advancements in cancer research. Jared has also served as associate marketing specialist for International Data Corporation (IDC), a market research firm. In this position, he planned and executed strategic marketing initiatives for IDC's software and services research programs, and wrote outbound communications to the press, existing clients, and prospects. Jared also has experience working for several local newspapers in eastern Massachusetts. Jared graduated with honors from Colby College with a BA in English and creative writing.
More about Jared Berezin