[AccessD] Optimizing Access for SQL Server

I have to say, the interaction between Access and SQL Server is nothing if not convoluted.

Did you read the sql exchange between JET and SQL Server?

John W. Colby
www.ColbyConsulting.com

On 6/7/2011 10:06 AM, Jim Dettman wrote:
> Some of you may find this interesting:
>
>   <http://msdn.microsoft.com/en-us/library/bb188204.aspx#optaccsql_topic5>
> http://msdn.microsoft.com/en-us/library/bb188204.aspx#optaccsql_topic5
>
>   It's a link to an article by Andy Baron on optimizing Access with SQL
> Server; some *very* nice detail on how JET actually implements the keyset
> cursor, chooses it's bookmark column(s), etc.
>
>    I haven't read the whole thing yet, but from what I've read so far, if you
> work with Access and SQL server, it's definitely worth the time to give a
> run through.
>
>    Interestingly enough, it's an "SQL" article, so I can see why many might
> miss this.  Access types don't typically look for SQL articles and SQL types
> will do the "Oh, it's Access" and ignore it<g>.  In fact I'm wondering why
> it was not published as an Access article...
>
> Jim.