Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you start Microsoft FRx: “Run-Time Error '3051': The Microsoft Jet Database Engine Cannot Open the File”


Symptoms

When you start FRx or generate a report, you receive the following error message:

Run-time error '3051': The Microsoft Jet database engine cannot open the file '\\server\share\FRx\Sysdata\FRxQue32.mdb'. It is already opened exclusively by another user, or you need permission to view its data
.

↑ Back to the top


Cause

The file listed in the error message has the read-only attribute selected, or the user has insufficient permissions for the directory containing the file.

↑ Back to the top


Resolution

  1. Using Windows Explorer, browse to the directory listed in the error message. Right-click the file listed in the error message, and then click Properties.
  2. Verify that the Read Only check box is not selected in the Attributes section. If it is, clear it. Click OK.
  3. Move up one level to the parent of the current directory. For example, if you browsed to \\server\share\FRx\Sysdata\, moving up one level should display the \\server\share\FRx\directory.
  4. Right-click on the directory containing the listed file, and then click Properties. In our example, this would be the SysData directory.
  5. Click on the Security tab. Verify that all FRx users have Read, Read & Execute, Write, and Modify permissions for the directory. If any users are missing these permissions, add the permissions, and then click OK. Repeat the action that caused the error - the error should no longer occur.
 

↑ Back to the top


References

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 966131
Revision : 3
Created on : 3/30/2017
Published on : 3/30/2017
Exists online : False
Views : 67