[AccessD] Optimizing Access for SQL Server

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.