[AccessD] Optimizing Access for SQL Server

jwcolby jwcolby at colbyconsulting.com
Tue Jun 7 10:21:09 CDT 2011


Thanks for this link!

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.



More information about the AccessD mailing list