Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Closing Data

Status
Not open for further replies.

safraser

Programmer
Apr 12, 2001
76
NZ
We have a client who is reporting he is having problems trying to run re-indexing routines on a application that we have given him.
The last thing that happens before the re-indexing routine starts is "Close Databases All". Yet when re-indexing tries to open the files exclusively, he gets error number 1705, File access is denied.
It is on a client server system, with about a dozen work stations, But he tells us that all (except for one to do the re-index in) copies of the are closed once again with close databases all in the clean up code.
Is there any other tricks that we can do to make sure that all tables are closed.

 
The close data all command certainly should close all fox tables that your session has open. I suspect it is case where another user has it open (I know they said no-way) or the network has not released the handle somehow.

Take a look at the following thread. It will provide you information on how to check to see if someone has a table open. Basically, it tries to read it using a low-level read. If it cannot do that - some other process is using it.

How to know if a table is already open
thread184-751652

Jim Osieczonek
Delta Business Group, LLC
 
Thanks Guys for the quick respones.
I think I may of just figured it out. I have just been told by the client that they have also been having Error Reading File errors from client computers.

Is it possible that the clients are loseing the file handles here meaning the it can't close the files properly?
 
Almost anything is possible so it is hard to say for sure what is happening.

The thread I pointed you to will not solve the problem - it is simply a way to determine if you are able to open the file exclusively. If not - you can provide them an info message or decide not to reindex at that time. It is better than receiving an error. However, you still don't know for sure what process has the file in use.



Jim Osieczonek
Delta Business Group, LLC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top