|
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.
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.
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:
• Read
• Write
• Create
• Delete
5. Click OK to save the changes.
|