DBF File in Use Error....

[jacky10]

Hi Friends,

The company which i joined newly were using an Project Estimation package develped using Clipper-Dbase. since last week it is prompting an error which reads like

Proc Net_use line 39 Open Error c:\estqtn\pmd\tcontrol.dbf in use....

where as tcontrol.dbf is present in c:\estqtn which is the working folder and theres no folder called PMD..! Tried to figure out the bug in the .prg files but couldnt...nevertheless it was working fine till last week...

any help, i would highly appreciate

thanx
rd prasannna

 

[ZoDra]

Hi prasannna,

It would help if you stated a whole message; nevertheless i think somebody or something is already accessing this file and your program is trying to open it in exclusive mode.

Check source; if there is no
set exclusive off

and open is issued like:

use mydbf index ...

then I might be right.

best regards
Drago

 

[jacky10]

hi drago..

thanx for the suggestion...

regarding the the Error Message... this is the only error message prompted...

"Proc Net_use line 39 Open Error c:\estqtn\pmd\tcontrol.dbf in use...."

and had tried re-booting the server as well as client couple of times to ensure that the file is released....

however wud check if the set exclusive is ON in the source...

thanx
rd prasannna

 

[JockMullin]

Hi Prasannna

If that folder doesn't exist, then likely the program is interpreting the open error incorrectly - i.e. a path not found error is being misinterpreted as a sharing violation, because that is much more likely to occur.

Why don't you make a folder called pmd and put a copy of that file down there and see what happens?

Jock

 

[jacky10]

hi jock

that was the first thing(creating a folder called pmd) i'd tried.... but dint work... was getting same error....

thanx anyways...
rd prasannna

 

[JCreamerII]

prasanna,

Can you slide the first 40 lines or so of the PROC Net_use into this thread so we can see what the code is trying to do at the point it errors out. There may be a clue that isn't obvious about what's going on at the point it is breaking.

Have you updated your server OS or desk top's OS lately. I've seen similar issues when an update to the desk top was done, Windows wasn't releasing the DBF it was staying open and causing this type of error.

Jim C.

 

[JockMullin]

Hi, Prasannna

OK so that file is on a server. Are you getting this error on the server itself? I am wondering since it refers to drive C:

What is the server OS?

Can you look on the server to see who has that file open and locked? Are you sure the account has read and write priveledges in the working folder?

There is the question of opportunistic locking on Windows servers, but that usually causes locks to be ineffective, which doesn't seem to be the case here.

Is there any chance someone has/is opening that file in a non-network aware program, such as Excel? Have you checked the attributes of that file with the dos ATTRIB command to make sure it is not read only or system?

Are you SURE you are looking at the right tcontrol.dbf file? I'm thinking since the message points to drive C:, maybe there is supposed to be a local working copy on each workstation.

Just a few shots in the dark.

jock

 

[jacky10]

Hurray ...

Dudes its working now.......

tellu wat i did...

first i created a folder called pmd (which i did earlier and Jock also has suggested)

then i just overwrote the tcontrol.dbf from the previous year data folder... hence my assumption is the tcontrol.dbf is corrupt?????!!!!! Assumption Though... or rather Fluke????

anyways thanx to u all... will comeback 2 u if it bugs me up again...

best regards
rd prasannna

 

[GriffMG]

It *sounds* like the file header was corrupt - perhaps someone had opened the file in Excel or somesuch?



Regards

Griff
Keep [Smile]ing