Issue: The following error message is received when a user attempts to run reports.

Error Message: "DAO.Workspace error. The Microsoft Jet database engine cannot open the file \\Servername\FCSServer\Temp\wsT... It is already opened exclusively by another user, or you need permission to view data."

Cause: This error is typically caused by inadequate permissions to the workspace path. The workspace path is a shared folder on the WSO Server that is used during report generation. The location of the workspace path is defined in the ws_srvr.ini, located under the path C:\Program Files (x86)\FCS\WSO\Server\INI.

Solution: Within the ws_srvr.ini, the following text context defines the workspace path location:
[SERVER]
WorkspacePath=\\servername\fcsServer\Temp\

• Confirm that the Share permissions on the FCSServer share are set to at least Change for the users running the reports.
• Confirm that the NTFS permissions are set to at least Modify on the Temp folder (or whatever folder is defined in the ws_srvr.ini) for the users running the reports.

More Information: This issue may occur in all 10.x and below versions of WSO Reporting and on some custom reports in 11.x and above.