INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

DBF File in Use Error....

DBF File in Use Error....

(OP)

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

RE: DBF File in Use Error....

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

RE: DBF File in Use Error....

(OP)
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

RE: DBF File in Use Error....

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

RE: DBF File in Use Error....

(OP)
hi jock

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

thanx anyways...
rd prasannna

RE: DBF File in Use Error....

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.




RE: DBF File in Use Error....

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

RE: DBF File in Use Error....

(OP)
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...smile

best regards
rd prasannna

RE: DBF File in Use Error....

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

Regards

Griff
Keep ing

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close