• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1119
  • Last Modified:

VFP9 error 2091 and access denied issues Server 2008 remote desktop.

We just completed a data and application migration from a Windows 2000 server to a Windows 2008 server environment. I'm having intermittent issues with my VFP9 applications.

The applications are running on a Windows 2008 R2 remote desktop server. The user sessions have drives mapped to the new file server, also a Windows Server 2008 R2, 64 bit.

I'm seeing intermittent errors, like 2091 - "table has become corrupted." Where the table of interest is not corrupted, and can be opened from vfp9.

Also, intermittently, I'll see 'access denied' errors opening a table. Examination of the security properties of the folder and tables in question shows Everyone to have full control.

any suggestions would be helpful.
  • 2
1 Solution
Switch off SMB2 both on the server and workstations. Also oplocks should not be used for shared files access. Windows administrators should know how to do it.

Antivirus software should not check DBF and CDX data files and also other fox-related files like SCX, SCT, VCX, VCT, APP, ...
I might add that you should probably run testing in a local access to the SQL Server (not using Remote Desktop) to minimize the variables and to ensure that there are no contributing factors being introduced by accessing via Remote Deskop.

Good Luck
jn2112Author Commented:
Had to look up how to turn off smb2 and opportunistic file locking elsewhere, but the solution was accurate
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now