Updating sql tables when joined devilfishdating com
In an application that uses linked SQL Server tables, two different database engines are at work: the Office Access/Jet database engine that runs on the Office Access client and the SQL Server database engine.The interaction of these two engines can sometimes yield results that are inferior to those obtained by using only the Jet database engine with native Office Access tables.Andy Baron November 2006 Applies to: Microsoft SQL Server 2005 Summary: One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables.This is the type of application created by using the SQL Server Migration Assistant for Office Access.There are two tools that you can use to see how Office Access is communicating with SQL Server.
This occurs because sometimes the Office Access database engine determines that it cannot submit an entire query to SQL Server.
Instead, it submits multiple queries, often including queries that request all of the rows in a table, and then it combines or filters the data on the client.
If the criteria require local processing, even queries that should return only selected rows from a single table can require that all the rows in the table be returned.
In some cases, performance of certain queries degrades to an unacceptable level.
The major cause of query performance degradation is when a query involving very large tables requires that all of the data from one or more tables be downloaded to the client.