[AccessD] Access Chart Control - Access 2016 vs Access 365 subscription

Fri Oct 26 20:04:30 CDT 2018

Jim,
Yes I spoke to Microsoft support person yesterday and pointed out on their
article Access 2016 is referred to as having the chart control.
He had to kick it upwards and gave me a phone number and a case reference
number.
I checked and you are right the reference to Access 2016 has quickly been
removed.
I took a screen shot of  yesterday's web page - just to feed the embers of
my simmering indignation...
I have no doubt it was intentional - the more ways of subterfuge so MS can
get everyone on the subscription path the better.

I do have a standalone .accdb with one form with one tab control and five
tab pages with a new line chart on each tab page.
Two local tables are the source for some sql select statements being the
rowsource for each line chart.
I've reduced the .accdb form down to having absolutely no code behind the
form.
During some of these iterations of reducing the code (debug - rem offending
code - debug - rem - etc - until I decided to remove all unnecessary
navigation controls and command buttons and form sizing code on the form
open event) I would get an exception message when opening the form, saying :
"The expression On Open you entered as the event property setting produced
the following error: A problem occurred while Microsoft Access was
communicating with the OLE server or ActiveX Control.
* The expression may not result in the name of ....."
To me that was weird as any code on the Form On Open had no reference to
OLE or active x controls...

With no code behind the Form, in Access 2016 the Form just opens and shows
no chart controls. The tab page tab headers are visible - the tab page with
focus just appear grey.
The moment I click on to a tab page Access falls over.

When I bring the same .accdb back into the Access for Office 365
environment the chart controls displays nice.

I will contact Microsoft to see if they want the .accdb

Re "the new linked table manager" - is there a writeup / info about that,
that you can provide a link to?

/borge

On Sat, Oct 27, 2018 at 3:24 AM Jim Dettman <jimdettman at verizon.net> wrote:

> Borge
>
>  The tags on the help article you point to have been corrected.
>
>  There is actually a very long story behind the "why" it had it (it was
> intentional and not a mistake), but suffice to say there are a number of
> articles like this and the work to clean them up is on-going.   It is an
> Office wide problem related to versioning and not just Access.
>
>  And if you can reproduce the crash in 2016, Microsoft would like to get a
> sample DB.   If a sample DB is not possible, then as much detail as
> possible
> as to what occurred.
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Jim
> Dettman
> Sent: Friday, October 26, 2018 7:48 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Access Chart Control - Access 2016 vs Access 365
> subscription
>
> <<
> OBVIOUSLY the "new charts" feature is not implemented in Office 2016
> Professional Pro... at least not in the version of the client...
> >>
>
>   That would be correct.
>
>   All "new" features at this point are introduced only in O365.   The
> perpetual releases will pick up new features that exist as of their RTM and
> if I understand correctly, will get no new features after that in any
> service packs.  For example, the new Linked table manager is found only in
> O365, as it missed the cut-off for Office 2019, but charts is in Access
> 2019.
>
>   With that said, it should not be causing Access 2016 to crash....it
> should
> simply not work.  If you are crashing and can do a small sample DB that
> shows this, I'm sure Microsoft would be very interested.
>
> << The link again is:
>
> https://support.office.com/en-us/article/create-a-chart-on-a-form-or-report-
> 1a463106-65d0-4dbb-9d66-4ecb737ea7f7
> <https://support.office.com/en-us/article/create-a-chart-on-a-form-or-report-1a463106-65d0-4dbb-9d66-4ecb737ea7f7>
> >>
>
>   I'll pass this along.
>
>   Bottom line though is that the new modern charting is only available in
> 2019 perpetual and O365.   All versions will support the old charting.
>
> Jim.
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Borge Hansen
> Sent: Friday, October 26, 2018 1:08 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access Chart Control - Access 2016 vs Access 365
> subscription
>
> No, and AFIAK Access cannot be installed on a Mac.
>
> Client is running a number of RDP on a green cloud WIndows Server 12 -
> their SQL Db on a separate vm ..
> About 6 months ago their Office was upgraded to Office 2016 Professional
> Pro
> The File >> Account >> About Access reports:
> Microsoft Access 2016 MSO(16.0.4738.1000) 32-bit
> Product ID: 00339-10000-00000-AA844
>
> On Access in both environments I have set the ActiveX Settings to "Enable
> all controls without restrictions ....." and "Safe Mode" is ticked OFF - It
> used to be "Prompt me...." and "Safe Mode" ON .
> I made the change yesterday and it makes no difference - will probably
> revert to original settings
>
>
> I run Office 355 on a VMWare Fusion virtual machine Windows 8.1 on a
> Macbook Pro with 16Gb RAM.
> The SQL Db Express is running on a Windows 7 vm on the same Macbook.
> The File >> Account >> About Access reports:
> Microsoft Access 2016 MSO (16.0.10228.20080) 32-bit
> Product ID: 00201-10951-41243-AA733
>
> Under File >> Account >> What's New (see the most recently installed
> updates) I read:
> "What's New in Access
> Your latest Office 365 features
> Remodel your forms and reports with new charts
> Create modern-looking charts in forms and report. Match fields to chart
> dimensions and preview your changes instantly.
> *Learn More  *    Close"
>
> OBVIOUSLY the "new charts" feature is not implemented in Office 2016
> Professional Pro... at least not in the version of the client...
>
> The client needed some stats - and as I knew a visual presentation more
> than anything else would make it clear what's going I set up a Form and
> some local tables to display four line graphs.
> Haven't worked with Access' ActiveX graph since Access2003 and I knew it
> had poor reputation - but I thought a simple line graph... right?
>
> Spent wasted hours into the night lasst night trying to figure why I could
> not do an export / import of the above self contained form and local tables
> into the client's production system...
>
> Writing up this email made it clear to me what is happening here..
> And I remember reading that the various Office versions especially between
> the perpetual license and subscriber license have varying update
> channels/paths/periods...
> Now it really did bite me hard!
>
> I am ranting - I know - but this is despicable!!
>
> Clicking through on the Learn More reference above I get to the same
> article that I linked to yesterday....
> On the top it says the this article relates to:
> Access for Office 365, Access 2019, Access 2016
>
> The link again is:
>
> https://support.office.com/en-us/article/create-a-chart-on-a-form-or-report-
> 1a463106-65d0-4dbb-9d66-4ecb737ea7f7
> <https://support.office.com/en-us/article/create-a-chart-on-a-form-or-report-1a463106-65d0-4dbb-9d66-4ecb737ea7f7>
>
> I fed back to Microsoft that I think it is imperative they include version
> number in their "this article relates to ...."
>
> I now have to find out from which version on will Microsoft Access 2016
> have the new Active X control installed - as it appears it is from the
> article!
>
> Again, for anyone else on the list beware of mixing Office 2016 perpetual
> and subscriber licenses...
>
> I will provide more information as to version of Microsoft Access 2016 that
> have the new chart controls...
>
> /borge
>
>
>
>
>
> On Fri, Oct 26, 2018 at 11:57 AM Darryl Collins <
> darryl at whittleconsulting.com.au> wrote:
>
> > Is one of the users on a Mac?  Active X doesn't work on Macs.  Just a
> > guess.
> >
> >
> >
> > -----Original Message-----
> > From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Borge
> > Hansen
> > Sent: Friday, 26 October 2018 5:37 AM
> > To: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>
> > Subject: [AccessD] Access Chart Control - Access 2016 vs Access 365
> > subscription
> >
> > I am baffled!
> >
> > In Access 365 subscription license 32 bit I have a Form with a tabcontrol
> > with 4 tab pages with a chart control on each tab page. data source for
> the
> > charts are two small local tables. The Db is compiled and tested and
> works
> > fine.
> >
> > I copy the .accdb file via OneDrive to a client's 2012 Server with Access
> > 2016 32 bit perpetual license installed.
> > The chart controls are nowhere to be seen in design view of the Form.
> When
> > running the form the .accdb crashes!
> >
> > This is driving me crazy!
> >
> > Despite both Access versions being referred to as Access 2016 is MS using
> > different active x controls in perpetual license vs their 365
> subscription
> > license??
> >
> > Anyone??
> >
> > /borge
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>