Start Updating sql tables when joined

Updating sql tables when joined

There are two tools that you can use to see how Office Access is communicating with SQL Server.

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.

It is very important to return to the Registry Editor and turn the feature off by changing the Trace SQLMode setting back to 0 when you are done testing. All the quotation marks that you see around object names are comparable to the brackets that Office Access uses (and that also can be used in SQL Server) to handle spaces or other illegal characters in names.

Running SQL Profiler also has a negative impact on performance, so try to avoid using it on a production server and close your Profiler traces when you are done testing. SQLPrepare is used to define a parameterized query that is then executed with SQLExecute.

The primary strategy for improving performance is to minimize the amount of data returned to the Office Access client and maximize the amount of processing that occurs on the server.

To accomplish this, you need to be able to analyze the SQL commands that Office Access is submitting.

In some cases, performance of certain queries degrades to an unacceptable level.