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

[Jim Dettman]

<< I have no doubt it was intentional - the more ways of subterfuge so MS
can
get everyone on the subscription path the better.>>

  Can't go into a lot of detail, but the reason behind it was a technical
one.   In some ways, Microsoft is moving at light speed when it comes to
products and how they are offered.

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

  They want to see the DB and will be in touch.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Borge Hansen
Sent: Friday, October 26, 2018 9:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Chart Control - Access 2016 vs Access 365
subscription

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.
>
<<snip>>