While setting up application’s that uses Visual FoxPro DB Files and thus needs ODBC Visual FoxPro Driver, you’ll see below error messages if the user doesn’t have proper access rights to the db files.
ERRORS:
—————————
Error
—————————
System error! [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor
—————————
OK
—————————
—————————
Error
—————————
System error! [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
—————————
OK
—————————
CAUSE: The most common cause for these errors are you (the user facing the error) don’t have Write access to the .dbf and .cdx files.
TROUBLESHOOTING:
Use Procmon and capture the .dbf and .cdf files for whose “Access is Denied” reported and provide access to the user.
FIX: Some application come bundled with a bunch of .dbf and .cdx files, it’s probably makes more sense to provide write access to the users on the whole directory where you have .dbf/.cdx files stored.
