Solved

Can't get exclusive access to VFP9 DBF on server

Posted on 2014-03-16
4
575 Views
Last Modified: 2014-03-17
Suddenly, after four years smooth sailing,  I can't get exclusive access in VFP9 to the DBC or a DBF to modify a file in my application.
Files are on Windows Server 2008, R2. I am logging in from home to my work computer via VPN and RDC.
I did some housekeeping Thursday and modified 4 databases, getting rid of old files, using this process:
SET EXCLUSIVE ON
OPEN DATABASE inventory
REMOVE TABLE edicases delete
REMOVE TABLE edi_recv_hd_875 delete
CLOSE DATABASES

I did not touch one DBC, and find I can get exclusive access to it. The four I did remove tables from, I can no longer get exclusive access to for changes.

The app was in regular use Friday, with 10 users (all local). One got an error message at the start of the day "Error reading file . . .\inventory.dbc" , but not again, and multiple people used the inventory DBC with no issue.

I am 99.9% sure no one else is currently using the app, which of course would prevent me from getting exclusive access to files.
0
Comment
Question by:terrypba1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
Gregory Miller earned 250 total points
ID: 39933063
Have you tried either restarting the DB Service or restarting the server to eliminate the stray locks?
0
 

Author Comment

by:terrypba1
ID: 39933109
Hadn't thought of that. Like I say, there have been so few problems with Foxpro itself I haven't had to poke around the server very much. Will the server have a discrete DB Service? I won't be able to try anything until tomorrow.
0
 
LVL 42

Assisted Solution

by:pcelba
pcelba earned 250 total points
ID: 39933208
FoxPro has no DB Service because it works as file server.

I suppose the error reported is "File access denied" in your case.

Refused exclusive access means file open by some other user/process. You have to look at open files list and identify the remote user which has files open. You may force disconnect of users having the file open. The first step should be to look if there isn't your past remote session still connected...

If files are open by some local process then you cannot see it and the only solution is to restart the whole server.

Error reading file means low level reading file error which is caused by damaged disk, lost network connection, or by antivirus blocking an access to the file. Antivirus should not block the file forever.
0
 

Author Closing Comment

by:terrypba1
ID: 39935577
Thanks! Restarting the server did the trick.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question