[AccessD] 97 to 2007 Performance issue

Charlotte,

I'm not sure that new features will slow Access.
The perf issue comes when the front end requires
data from the back end.
And to my knowledge, ODBC is the piece of software that
do this data transfer.
If a new version of ODBC is used by A2007, and don't see why it would be
slower
than any previous one.
Do you think that there are any tuning options that would affect
performance?

Philippe Pons

2011/7/25 Charlotte Foust <charlotte.foust at gmail.com>

> Because 2007 is fat with "end user" features for all the developer wannabes
> MS is aiming at.  A97 was still mostly restricted on the bells and whistles
> to the stuff developers would want to use ... and knew how to!  VBA alone
> has increased to a huge size in anything later than 2002.
>
> Charlotte Foust
>
> On Sun, Jul 24, 2011 at 7:27 PM, Stuart McLachlan <stuart at lexacorp.com.pg
> >wrote:
>
> > Short answer.  It's a Microsoft product.  Every new version of everything
> > they have ever
> > released uses more resources and takes longer to do the same thing (with
> > the possible
> > except of Win 7 over Vista)   :-)
> >
> > --
> > Stuart
> >
> >
> > On 24 Jul 2011 at 22:19, William Benson wrote:
> >
> > > I will add my plea for information and a means of understanding. .. I
> > > totally agree it is slower and would like to know why.
> > >
> > > Data sheet form filtering, refreshing forms, requeryng controls in
> > > particular. -- 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
>