Can't get exclusive access to VFP9 DBF on server

Posted on 2014-03-16
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:
REMOVE TABLE edicases delete
REMOVE TABLE edi_recv_hd_875 delete

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.
Question by:terrypba1
  • 2
LVL 11

Accepted Solution

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

Author Comment

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.
LVL 41

Assisted Solution

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.

Author Closing Comment

ID: 39935577
Thanks! Restarting the server did the trick.

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to know which tables getting lock escalation 4 50
SSRS troubles 4 50
Foxpro errors 4 30
How to design the database - mvc code first entity framework 1 36
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

776 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