philippe pons
phpons at gmail.com
Mon Jul 25 02:22:42 CDT 2011
Stuart, You are probably right, and as DAO is optimized for Access, performance should be better than with ODBC. Philippe 2011/7/25 Stuart McLachlan <stuart at lexacorp.com.pg> > 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 > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >