.Net &.LCK file In paradoxe DB

[walid76]

hello
when i use paradoxe in network some application can not run and gifs the message "database loocked by another .net file..."
what is this broblem and how can i repar it?
pleas help quickly & thanks

[HTML]

Hello & welcome to the forum.

You should scan all folders where the Tables recide and check and delete files named Paradox.lck and Pdoxusrs.lck, before you open any Tables.

Also reading this article is recommended if you have a client server application.
http://community.borland.com/article/0,1410,15247,00.html

Hope this helps.

P.S
In the future you may also want to search the forum, this question has been asked a couple of times.

[GeoWink]

Be sure that each user PC has the BDE installed, if that is what you are using, and that all of them point to the same location for the .NET file. That is important. If this is not the case you will get all kinds of LCK files left and users won't be able to use the app.

George

[Robert_Thompson]

Here is the code we use, placed in the first form opened:

procedure TMenuForm.FormCreate(Sender: TObject);
var
Dir: string;
begin
Dir := 'C:\Priv\appname';
ForceDirectories(Dir);
session.PrivateDir := 'C:\Priv\appname';
Session.NetFileDir := 'H:\Net\appname';

end;

The directory 'C:\Priv\appname' is created on every PC when the app is first run.

We created, manually, 'H:\Net\appname'. (H is our network drive)

The pdoxusrs.net file is created in 'H:\Net\appname' automatically when the app starts.

I think that you should delete all PDOXUSRS.NET and PDOXUSRS.LCK files before you implement this change.

HTH,

Rob.