Access updating using linked 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.

Select a template that shows TSQL to see all the statements being processed by the server.

This occurs because sometimes the Office Access database engine determines that it cannot submit an entire query to SQL Server.Before you can make productive use of these diagnostic tools, you must understand how Office Access interacts with SQL Server. The question marks are placeholders for parameters.Without that understanding, the SQL statements that you see in Profiler traces and in Sqlout logs can be quite puzzling. MULTI-ROW FETCH indicates that parameter values are submitted, based on values retrieved by the first query, to retrieve up to 10 rows.To enable tracing of all ODBC commands from the Jet database engine: After making this change in the registry, queries submitted to any ODBC data source are logged in a text file named Unless you delete this file or its contents, it continues to grow as new queries are executed and the tracing activity degrades performance. SQLExecute: (MULTI-ROW FETCH) SQLExec Direct indicates execution of a non-parameterized query.

Leave a Reply