Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
A C
 
Posts: n/a
Default Help: pivot chart data in secured Access database wont show fields

Hello

Is there a way for me to crate a pivot chart in Excel where the data is in a
secured access database.

By default (ie using system.mdw) the Access security allows a user view
permissions on the tables. When connecting to the database the tables are
visible, but the next step where the fields get shown doesnt happen, no
fields can be selected.

Is this a security issue? Is there a way around this?

Thanks
A


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show value in Data Table but not on live chart Gonepostal Charts and Charting in Excel 1 January 17th 06 01:23 PM
Excel as Data Entry into Access Database Btibert Excel Discussion (Misc queries) 3 August 29th 05 02:17 PM
Pivot Table - show items with no data HJM Excel Discussion (Misc queries) 3 June 22nd 05 12:51 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Can you show data in a data table but not plot it on the chart? Armadillo Charts and Charting in Excel 2 May 19th 05 01:08 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"