[AccessD] 97 to 2007 Performance issue

Access to Access links don't  use ODBC, AFAIK, they use DAO for linked tables.

-- 
Stuart

On 25 Jul 2011 at 7:56, philippe pons wrote:

> 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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>