Re: Access and processor usage ..."increased bandwidth" using ADO.... bottleneck - need to step up to Sql Server.... If the data fits into a 2 GB database file,... (comp.databases.ms-access)
Re: Connecting to a SQL Server 2005 using VBA and ADO ...dao should work just fine.... ... the above example when using sql server, or a plan Jane un-split database,... I would not use findfirst even when not using sql server unless the data set ... Microsoft since they now seem to be favoring ADO.... (microsoft.public.access.formscoding)
Re: Access and processor usage ... developers to get together and develop reproducible test scenarios,... See http://www.QBuilt.com for all your database needs.... "increased bandwidth" using ADO.... bottleneck - need to step up to Sql Server.... (comp.databases.ms-access)