Table locked when displayed in subform
I have a table that gets populated with a couple queries. When that table is opened, it becomes locked and the queries will not function. To avoid having people open the table directly to view the data, I'd display the table in a datasheet view in a form with the recordset snapshot (which i've done already) but even displaying it here locks it. I can't see any combination of settings that prevents this table from getting locked. If the datasheet property is Locked:Yes, it can't be manually edited but the table itself gets locked and the query won't update it. If i change the properties to Locked:No, it still locks the table anyway and the queries still fail (but the data is editable within the subform?!). Any idea how I can display this table without locking it? The form does contain another datasheet that i need to remain editable Bigger picture: Ultimately I'm trying to get this table displayed in a subform in a form while remaining not locked so that the queries run via VBA can make changes without error. The form contains access to a datasheet to enter data, a couple buttons for VBA, and this table as a display for results. The form has Record Locks: No Locks. The subform has Locked: No (changing this does nothing). None of this really matters: ultimately the issue is when that table is opened, it becomes locked and the queries will not function. When the table is displayed in the subform, it becomes locked the same way. How can I ensure that a table is viewed in a way that does not lock it?
Azure Site recovery clearing locks
Recently had an issue in re-protecting VM's following failover to a secondary region. Tried everything and couldn't resolve eventually after speaking with Azure support i ran the below script and resolved the issue with locks not clearing on failed over VM's cls $subscriptionId = Read-Host 'What is your Azure Subscription ID?' $rgName = Read-Host 'Specify the name of the Resource group in which your VM is located' $vmName = Read-Host 'Specify the name of the VM' # Sign-in with Azure account credentials Login-AzureRmAccount # Select Azure Subscription Select-AzureRmSubscription -SubscriptionId $subscriptionId # Remove any locks $locks = Get-AzureRmResourceLock -ResourceGroupName $rgName -ResourceName $vmName -ResourceType Microsoft.Compute/virtualMachines if ($locks -ne $null -and $locks.Count -ge 0){ $canDelete = Read-Host 'The VM has locks that could prevent cleanup of Azure Site Recovery stale links left from previous protection. Do you want the locks deleted to ensure cleanup goes smoothly? Reply with Y/N.' if ($canDelete.ToLower() -eq "y"){ Foreach ($lock in $locks) { $lockId = $lock.LockId Remove-AzureRmResourceLock -LockId $lockId -Force Write-Host "Removed Lock $lockId for $vmName" } } } $linksResourceId = 'https://management.azure.com/subscriptions/' + $subscriptionId + '/providers/Microsoft.Resources/links' $vmId = '/subscriptions/' + $subscriptionId + '/resourceGroups/' + $rgName + '/providers/Microsoft.Compute/virtualMachines/' + $vmName + '/' Write-Host $("Deleting links for $vmId using resourceId: $linksResourceId") $links = @(Get-AzureRmResource -ResourceId $linksResourceId| Where-Object {$_.Properties.sourceId -match $vmId -and $_.Properties.targetId.ToLower().Contains("microsoft.recoveryservices/vaults")}) Write-Host "Links to be deleted" $links #Delete all links which are of type Foreach ($link in $links) { Write-Host $("Deleting link " + $link.Name) Remove-AzureRmResource -ResourceId $link.ResourceId -Force } $links = @(Get-AzureRmResource -ResourceId $linksResourceId| Where-Object {$_.Properties.sourceId -match $vmId -and $_.Properties.targetId.ToLower().Contains("/protecteditemarmid/")}) Write-Host "Cross subscription Links to be deleted" $links #Delete all links which are of type Foreach ($link in $links) { Write-Host $("Deleting link " + $link.Name) Remove-AzureRmResource -ResourceId $link.ResourceId -Force } Write-Host $("Deleted all links ")