LCK files seem to mysteriously hang around in the PRIV sometimes.

The appCrash is interesting, maybe whatever is causing the lck file delete
failure is resulting in that? Hard to tell what comes first, failed delete
or appcrash causes skipping the deletion.
If Paradox crashes, LCK files are orphaned. Long ago on my larger systems
I created a nightly sweep (or on reboot) that deletes all files s in all
users PRIV folder and deletes the NET file. It solved many issues.

Does your code have any attached table vars or not closed tcursors? Something
like that?

>
Since the Remote Desktop server from which the application is run was upgraded
from Server 2012 to 2019 the .LCK files in the user's private directory are
no longer being deleted when exiting PFW.
<

Where are the application files?
Do the users RDP to a server and run Paradox on it? Or is Paradox installed
on each PC?

If on a server, can you log into the server directly without RDP, open paradox,
edit a table, see the LCK file in your PRIV, close table, close paradox and
see LCK file delete?  (not using RDP)

Server 2012 to 2019 seems to be where to look, but if nothing else changed,
rights, architecture, NET file location same for all users, it seems odd.

What about UAC on the machines?
Liz suggested running as admin, try that, but not only login as admin, “RUN
AS” administrator.

Lastly, delete the NET file.





Liz McGuire <liz@paradoxcommunity.com> wrote:
>What happens if you run as administrator?  Just for testing purposes.  That
would help
>determine if it's a rights issue.  (Just because the users can do it does
not mean
>that an app, even if run as that user, has the rights.)  Also, have you
tried running
>Paradox in some compatibility mode - working backward - to see if that works?
>
>Oh, finally, make sure all antivirus software is set to ignore the Paradox
executable
>and all directories where it and the database files live.
>
>Liz
>
>
>On 25 Aug 2023 09:10, Bradley Wood wrote:
>> Steve,
>> 
>> Thanks for your responses!
>> 
>> 1. Local Share in the BDE was set to true.
>> 
>> 2. I was able to configure the startup and associated cleanup into a .bat
>> file as a temporary work around but I was hoping to identify some setting
>> (likely related to network security) that would prevent the AppCrash event
>> on exit when it attempts to delete the .lck files.  It's interesting that
>> it does cleanup all the temporary files in the :PRIV: dir that start with
>> the "__.." prefix but stumbles over the .lck files.
>> 
>> Again, thanks for your help.
>> 
>> Bradley Wood
>> 
>> Steve Green <steve@oasistradingpost.com> wrote:
>>>> As a final configuration point, SMB2/3 has been disabled on the RD &
>>>> App servers, SMB1 has been enabled, and OpLocks has been disabled.
>>>
>>> and Local Share in the BDE must be TRUE.. could be the solution needed,
>> too
>>>
>>>
>>>> Since the Remote Desktop server from which the application is run was
>> upgraded > from
>>> Server 2012 to 2019 the .LCK files in the user's private
>>> directory are> no longer being deleted when exiting PFW.
>>> you should be able to easily wrap the startup in a bat file and kill
the
>> 
>>> lock files first, if necessary
>>>
>>>
>>> -- 
>>> Steven Green
>>> Myrtle Beach, South Carolina USA
>>>
>>> http://www.OasisTradingPost.com
>>>
>>> Collectibles and Memorabilia
>>> Vintage Lego Sets and Parts
>>> - and Paradox support, too
>>>
>>