philippe pons
phpons at gmail.com
Mon Jul 25 02:54:54 CDT 2011
I remember that some guys recommended to keep an open connection to the back end, to reduce acces time. But I guess this does not apply to linked tables, as they will use a different connection, won't they? 2011/7/25 philippe pons <phpons at gmail.com> > 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 >> > >