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

Posted on 2011-05-09
Last Modified: 2012-05-11
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.
Question by:jn2112
    LVL 41

    Accepted 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, ...
    LVL 12

    Expert Comment

    LVL 12

    Expert Comment

    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

    Author Closing Comment

    Had to look up how to turn off smb2 and opportunistic file locking elsewhere, but the solution was accurate

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    We recently had an issue where out of nowhere, end users started indicating that their logins to our terminal server were just showing a "blank screen." After checking the usual suspects -- profiles, shell=explorer.exe in the registry, userinit.exe,…
    Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
    This tutorial will walk an individual through the process of upgrading their existing Backup Exec 2012 to 2014. Either install the CD\DVD into the drive and let it auto-start, or browse to the drive and double-click the Browser file: Select the ap…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now