Go Premium for a chance to win a PS4. Enter to Win


Can't get exclusive access to VFP9 DBF on server

Posted on 2014-03-16
Medium Priority
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 12

Accepted Solution

Gregory Miller earned 1000 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 43

Assisted Solution

pcelba earned 1000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article, we’ll look at how to deploy ProxySQL.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

916 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