[AccessD] Search in AC2007 and SQL-Server

Isn't the larger issue whether or not a stored procedure is called vs.
dynamic SQL ?
Also, what about ODBC vs. a native driver ?
I thought both of these were hugely important, no ?


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> David McAfee
> Sent: Friday, November 12, 2010 2:03 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Search in AC2007 and SQL-Server
>
> SQL Server will definitely be faster, but it really depends
> on what you are returning.
>
> How many fields are coming back? What type of fields are
> they? Are the WHERE clause fields indexed?