Hi all. I am back again. Last time

[araskas]

Hi all. I am back again. Last time I asked a question here I got a very satisfying solution from this forum. Now I am here with a new problem.
We have an application that has the datafiles in a separate folder. Application is FoxPro 2.6a for windows.
At the login screen
When I am trying to login to the application I am getting this message “An error occurred while attemting to open Table1. Another user may have the table locked.
Try Again ?
Yes NO
If I click I get the same message again and agin.
If I click No then I get similar message but this time saying Table2 is locked .
If I select NO for this message also then I get similar message for Table3 this is going on for 4 tabels.

Please tell me what how to fix it.

If I ignore all the messages then finally I get this message too - "File XCONFIG does not exist"

 

[ramani]

HI
Add the following code in the initial main prg where you put your initial SET codes...

SET EXCLUSIVE OFF

This will solve the problem ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[araskas]

Thanks Ramani for responding. This is an exe application that has been running for long time and about 15 users log in regularly. Any way I checked the main program and it is having "SET EXCLUSIVE OFF" . As a first step I asked all users to make sure that they are logged off the application. What next !

Thanks again

 

[JRB-Bldr]

From your initial posting, as Ramani has said, your problem is multiple users attempting to use the same data table which has been opened EXCLUSIVE.

Answering YES obviously will attempt to open the table again
and, without having resolved the problem, will fail again.

Answering NO will ignore the attempt to open the table and
your problems will "cascade" from then resulting in a variety of mis-leading error messages.

=============================
It is possible that in spite of SET EXCLUSIVE OFF in the
opening lines of the program, the code which actually attempts to open the table may be:
USE <Table1> EXCLUSIVE
This would over-ride the global setting.

Also possible is FLOCK() having been used within the code around the use of Table1.

Lastly some other &quot;down-stream&quot; FUNCTION or PROCEDURE
may contain the code: SET EXCLUSIVE ON

Assuming that you have access to the code, you may need to examine it more closely.

Good Luck,
jrbbldr
jrbbldr@yahoo.com

 

[davidtoranzo]

Hi,

What confuses things here is the fact that the application was working properly, so the problem can't reside in the code.

So I tend to think that the files stayed opened, maybe for some abnormal closing of the application. As a first action, you may force a general shutdown of servers and terminals, erase FPW generated temporary files and start again, to see what happens.

David.

 

[araskas]

Hello all,
We have decided to use teh backed up apllication folder adn Data files from the previous night. Thank you all of you for your response and showing interest in resolving my problem. I will definitely keep you informed on this problem.