When I execute a particular SQL query or attempt to alter the structure of an existing table I get the error "DBISAM Engine Error # 11013 Access denied to table 'xxxx'" ?

Frequently Asked Questions

When I execute a particular SQL query or attempt to alter the structure of an existing table I get the error "DBISAM Engine Error # 11013 Access denied to table 'xxxx'" ?

This can occur with local or remote sessions, but each has a different cause:

Connection

Cause

Local	The TDBISAMSession PrivateDir property is set to a non-existent directory, or to a directory that the current user does not have the proper read/write rights for.
Remote	The temporary files setting in the database server configuration is set to a non-existent directory. This can happen when you move copy a database server configuration from another machine. The TDBISAMSession PrivateDir property is not used with remote sessions.

This problem can also be caused by anti-virus software interfering with temporary file creation during the table alteration. If the conditions noted above do not apply to your system configuration and you are using an anti-virus software product on the affected machine(s), then you may have to disable real-time scanning in your anti-virus software to determine if it is responsible for the issue. Anti-virus software often tries to scan/quarantine temporary files that are created, and this is what causes this type of problem.

More Support Options

Support Forums

Technical Bulletins

Technical Articles

Incident Reports

Product Manuals

Roadmap