Sql updating joined tables

Rated 4.60/5 based on 660 customer reviews

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

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

The most common way this is done is by creating linked tables in Office Access that use the SQL Server ODBC driver to connect to tables in SQL Server databases.

The SQL Server Migration Assistant (SSMA) for Office Access enables you to convert an Office Access database to this type of application by moving your Office Access data to new SQL Server tables and linking to these tables.

Developers often migrate data to SQL Server expecting an improvement in application performance.Bear in mind that a view is not a table and contains no data—the actual modification always takes place at the table level.Views cannot be used as a mechanism to override any constraints, rules, or referential integrity defined in the base tables.Allowing updates in views with joins is likely to confuse users because it's not intuitive that they can't update different columns on the same row. If you want users to be able to use views to update data, base the view on a single table, or use a stored procedure to perform the update.The rules for updating user-defined inline functions are the same as they are for views.

Leave a Reply