File access is denied

2020-04-16 03:46发布

I'm using SQL command within FoxPro 6.0 command window, and encountered the "File access is denied."

My SQL command is:

SELECT * FROM main.dbf WHERE Client = "ABC"

Situation:

  • Windows 7 Pro
  • FoxPro 6.0 main.dbf is shared to many users.
  • main.dbf is not hidden and is not write only

Any comments will be greatly appreciated!

2条回答
姐就是有狂的资本
2楼-- · 2020-04-16 03:59

Maybe you need to open the DBF file in exclusive mode:

SET EXCLUSIVE ON

Then perform your SQL query.

查看更多
Lonely孤独者°
3楼-- · 2020-04-16 04:12

Is this DBF file on a shared drive? If so, another user may have the file open Exclusive, or you are trying to open the file Exclusive. By default, Foxpro tries to open tables exclusively.

In the command window or your program, issue these commands:

SET EXCLUSIVE OFF
USE main SHARED
SELECT * FROM main WHERE Client = "ABC"

If you still get the error, then you may want to download a tool that will show you a list of users that have the file open. Perhaps one of them have the DBF opened exclusive.

查看更多
登录 后发表回答