Pivot table in Access 2007 - is it the OWC, and is licensing the same?

[amos]

Are the pivot tables in Access 2007 basically the same as the OWC that
could be used with Access 2002 and 2003? The OWC was buggy and
documentation was very thin. But it was still useful in some cases.

Licensing for the OWC was not great either; you couldn't use it with the
runtime unless the end user had a license for retain Office. I hope
that's changed.

 

[Alvin Bruney [ASP.NET MVP]]

Pretty much any and everything goes because the technology has been retired.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Download OWC Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $15.00
Need a free copy of VSTS 2008 w/ MSDN Premium?
http://msmvps.com/blogs/alvin/Default.aspx

 

[amos]

Pretty much any and everything goes because the technology has been retired.

Not sure I understand. OWC, I expected it to be retired. But isn't that
OWC in Access 2007 again? Maybe you mean retired as = not being
developed any further...it does look just the same.

And I don't get what the implication is re licensing. It used to be that
OWC pivot tables were disable for changes unless a matching retail
Office license was found on that machine. 'anything goes' works for me,
but are the Access 2007 pivot tables 'pivotable' with the runtime, sans
any other Office installation?

 

[Alvin Bruney [ASP.NET MVP]]

There is no support of OWC in office 2007. OWC is uninstalled by Office
2007. Licensing checks in software are no longer being inforced. That only
applies for versions before 2007. It's unclear what the behavior is in 2007.
FYI,OWC11 targets version 2003 of Office for licensing purposes. They don't
require a specific version of office since they are statically linked in
which means you can always re-install for office 2007 products. I hope this
makes sense.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Download OWC Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $15.00
Need a free copy of VSTS 2008 w/ MSDN Premium?
http://msmvps.com/blogs/alvin/Default.aspx

 

[amos]

There is no support of OWC in office 2007. OWC is uninstalled by Office
2007. Licensing checks in software are no longer being inforced. That only
applies for versions before 2007. It's unclear what the behavior is in 2007.
FYI,OWC11 targets version 2003 of Office for licensing purposes. They don't
require a specific version of office since they are statically linked in
which means you can always re-install for office 2007 products. I hope this
makes sense.

Hmm..I'm not sure what it all adds up to. I sure appreciate your taking
the time to write this stuff up for me.

Licening checks are no longer being enforced - you mean with Access
2007? Or do you mean with Access 2003 and it's OWC? It sure used to be
enforced, but did sp3 change that?

One of my main questions was, what is the pivot table in Access? You've
made it clear that it's not owc...but is it something native to Access
2007 then? And do you happen to know if the pivot tables 'just work'
with the Access 2007 runtime? The Access 2007 pivot table sure looks
like the OWC but I didn't look at it for long.

If the Access 2007 pivot table is 'native' and useable with the runtime
(sans retail license), then for the app that uses pivot tables I might
push it to Access 2007, it's simplify some things.

 

[Alvin Bruney [ASP.NET MVP]]

When you play with this for a while, you'll get the picture then you can
refer to this thread and it will start making a bit more sense.

Licening checks are no longer being enforced - you mean with Access
2007?

With Office products after 2003 SP3 ( I think was when it changed).
Basically, these components should no longer be rendered in read-only mode
irrespective of what version of Office is on the desktop.

Access should have a version of OWC version 11 with an updated build number
or possibly version 12 which is simply a build increment, no functionality
change.

And do you happen to know if the pivot tables 'just work'

with the Access 2007 runtime?

It should just work because no new versions of OWC ship after Office 2003.
They likely piggy backed off of version 11. To say for sure, look at the
clsid of the OWC pivot table object in Access 2007 or the about box.

(sans retail license), then for the app that uses pivot tables I might
push it to Access 2007, it's simplify some things.

Essentially yes, since licensing checks are no longer being performed you
can interpret it any way you like. I choose to interpret it as, "I'm going
to do whatever I please with OWC from now on". It is more than likely that
we interpret this differently. I do not represent Microsoft's licensing
interest so my opinion is not binding.
--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Download OWC Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $15.00
Need a free copy of VSTS 2008 w/ MSDN Premium?
http://msmvps.com/blogs/alvin/Default.aspx

 

[amos]

OK, thanks, now I get the picture. I'm glad they've made it easier to
use the pivot table etc.