Microsoft KB Archive/928755

= The data in a workbook is not displayed when you use Excel Web Access to open a workbook that queries a Jet database =

Article ID: 928755

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Office SharePoint Server 2007

-



SYMPTOMS
You configure Microsoft Office SharePoint Server 2007 Excel Services to query a Microsoft Jet database. When you try to use Excel Web Access to open a Microsoft Office Excel workbook (.xml) file that queries the Jet database, the workbook opens. However, the data in the workbook is not displayed.



CAUSE
This issue occurs if the user account that is used to query the Jet database does not have the correct permissions to access the folder that contains the Jet database (.mdb) file.

The .mdb file should be located in a folder to which users have the following permissions:
 * Read
 * Write
 * Create
 * Delete

All users who access the database must have read, write, and create permissions to the folder. However, you can assign read-only permissions to the .mdb file for individual users while still granting full permissions to the folder.



WORKAROUND
To work around this issue, perform the following actions:
 * Add Microsoft.ACE.OLEDB.12.0 as an OLE-DB-type data provider in the trusted data providers list in Excel Services Settings.
 * Depending on the Excel server authentication settings that are defined in the Excel Data Connection settings, grant the required permissions to the account that Excel Services uses to create the connection to the folder that contains the Jet database file. For example, if you use the Windows Authentication setting, you must use the domain user account that you want to access the workbook on the server.

How to add a trusted data provider

 * 1) Click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
 * 2) On the Central Administration page, click Application Management.
 * 3) On the Application Management page, click Create or Configure this Farm’s Shared Services under Office SharePoint Server 2007 Shared Services.
 * 4) On the Manage This Farm's Shared Services page, click SharedServices1 (Default).
 * 5) On the Shared Services home page, click Trusted data providers under Excel Services Settings.
 * 6) On the Excel Services Trusted Data Providers page, click Add Trusted Data Provider.
 * 7) In the Provider ID section, type Microsoft.ACE.OLEDB.12.0.
 * 8) Under Provider Type, click OLE DB, and then click OK.

How to grant the required permissions

 * 1) In Windows Explorer, locate the folder that contains folder in which the .mdb file resides.
 * 2) Right-click the folder, and then click Properties.
 * 3) In the Folder Properties dialog box, click the Security tab.
 * 4) Make sure that the user account that you want to use has the following permissions:
 * 5) * Read
 * 6) * Write
 * 7) * Create
 * 8) * Delete
 * 9) Click OK to save the changes.

