# Allobj Locked and Locked By **URL:** \ **Category:** Developers Forum\ **Created:** [January 28, 2014, 11:26am UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570 "2014-01-28T11:26:25Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![colingbradley](https://avatars.discourse-cdn.com/v4/letter/c/bc8723/32.png) [@colingbradley](https://www.dynamicsuser.net/u/colingbradley)\ **Post date:** [January 28, 2014, 11:26am UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/1 "2014-01-28T11:26:25Z")
Anyone used the Locked option when in Object Designer? What is the purpose? Is it to prevent changes by any user? Who can use Locked? Is there anything from Microsoft on this? Cheers, Colin ---
**Author:** ![lvanvugt](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/lvanvugt/32/7500_2.png) [@lvanvugt](https://www.dynamicsuser.net/u/lvanvugt)\ **Post date:** [January 28, 2014, 12:58pm UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/2 "2014-01-28T12:58:53Z")
Have a look here: [Locking and Unlocking Objects](http://msdn.microsoft.com/en-us/library/gg502465(v=nav.60).aspx) ---
**Author:** ![colingbradley](https://avatars.discourse-cdn.com/v4/letter/c/bc8723/32.png) [@colingbradley](https://www.dynamicsuser.net/u/colingbradley)\ **Post date:** [January 28, 2014, 5:56pm UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/3 "2014-01-28T17:56:09Z")
Hmmm, it seems for some reason that the Locked and Locked by is shown on the Object Designer form but only on one particular version of NAV2009FR R1, not shown for NAV2009FR R2. I was of course aware of the need to lock tables with code but had never noticed it showing at the object level. Thanks, Colin ---
**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\ **Post date:** [January 28, 2014, 6:21pm UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/4 "2014-01-28T18:21:38Z")
Hi Colin, The object locking and unlocking functionality was released with NAV 2009 R2, so you shouldn’t see it in any version previous to 2009 R2. And it’s not country specific functionality as it’s part of the “platform” - not the application. Also are both versions you mention using SQL Server? As far as I know then it does not work on the native database. ---
**Author:** ![colingbradley](https://avatars.discourse-cdn.com/v4/letter/c/bc8723/32.png) [@colingbradley](https://www.dynamicsuser.net/u/colingbradley)\ **Post date:** [January 29, 2014, 8:53am UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/5 "2014-01-29T08:53:05Z")
Many thanks, that explains it all really well. Being a sole developer in most cases it does not impact on me but in a team situation I can see this as really useful. ---
**Author:** ![colingbradley](https://avatars.discourse-cdn.com/v4/letter/c/bc8723/32.png) [@colingbradley](https://www.dynamicsuser.net/u/colingbradley)\ **Post date:** [January 29, 2014, 8:55am UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/6 "2014-01-29T08:55:07Z")
Indeed, that does explain my situation, I had a local db open as well as the SQL db. Thanks for that. ---
**Author:** ![colingbradley](https://avatars.discourse-cdn.com/v4/letter/c/bc8723/32.png) [@colingbradley](https://www.dynamicsuser.net/u/colingbradley)\ **Post date:** [January 29, 2014, 8:56am UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/7 "2014-01-29T08:56:48Z")
All clear now, my thanks to Luc and Erik. ---
**Author:** ![lvanvugt](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/lvanvugt/32/7500_2.png) [@lvanvugt](https://www.dynamicsuser.net/u/lvanvugt)\ **Post date:** [January 29, 2014, 9:03am UTC](https://www.dynamicsuser.net/t/allobj-locked-and-locked-by/50570/8 "2014-01-29T09:03:15Z")
You’re welcome, Colin.