Optimizing Microsoft Office Access Applications Linked to SQL Server

Tom van Stiphout, fellow Access newsgroup denizen, alerted me to the following MSDN article: Optimizing Microsoft Office Access Applications Linked to SQL Server.  A link was also added to the Access Performance FAQ.

Note the following paragraph:

“Developers often migrate data to SQL Server expecting an improvement in application performance. Although performance does often improve, there are many cases where it remains the same or even degrades. In some cases, performance of certain queries degrades to an unacceptable level.”

2 thoughts on “Optimizing Microsoft Office Access Applications Linked to SQL Server”

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>