Save PivotChart View in Query

I apologize if I am asking this question in the wrong area. If this is the
case, please let me know where a better place to ask it is.
When I try to save a PivotChart View in Access 2003 connecting to SQL Server
2000, I get this message:
Object is invalid. Extended properties are not permitted on 'dbo.queryname',
or the object does not exist.
Is there a way to save my chart based on my query, or do I need to re-make
it every time I want to view it?
MatthewOne of the Access newsgroups would probably be a better
place to post this - PivotChart views are an Access thing
and don't have anything to do with SQL Server.
I vaguely remember there is someway to prevent changes to
the view - from selecting the properties on the PivotChart
toolbar. Something like that and that's all I can remember.
-Sue
On Wed, 26 Jan 2005 10:17:38 -0500, "Matthew"
<turn.deletethis@.alltel.net> wrote:

>I apologize if I am asking this question in the wrong area. If this is the
>case, please let me know where a better place to ask it is.
>When I try to save a PivotChart View in Access 2003 connecting to SQL Serve
r
>2000, I get this message:
>Object is invalid. Extended properties are not permitted on 'dbo.queryname'
,
>or the object does not exist.
>Is there a way to save my chart based on my query, or do I need to re-make
>it every time I want to view it?
>Matthew
>|||Sue,
I'll ask the question over there. Sorry about that.
Matthew
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:h2ogv0t376nmhv7s34gjp4lpdc1h3t3ttq@.
4ax.com...
> One of the Access newsgroups would probably be a better
> place to post this - PivotChart views are an Access thing
> and don't have anything to do with SQL Server.
> I vaguely remember there is someway to prevent changes to
> the view - from selecting the properties on the PivotChart
> toolbar. Something like that and that's all I can remember.
> -Sue
> On Wed, 26 Jan 2005 10:17:38 -0500, "Matthew"
> <turn.deletethis@.alltel.net> wrote:
>
>