Access updating using linked tables

6854933580_2c8b688306_z

The following table compares SQL Server and Access data types.

access updating using linked tables-89access updating using linked tables-74access updating using linked tables-17

You cannot add, delete, or change the fields in a linked table while you are working in Access.

In an import operation, Access never overwrites a table in the database.

Although you cannot directly append SQL Server data to an existing table, you can create an append query to append data after you have imported data from similar tables.

You can create a DSN file directly by using the Data Connection Manager.

For more information, see Administer ODBC data sources.

You can change the data either in SQL Server, or in Datasheet view or Form view from Access and the changes are reflected in both SQL and Access.

You must have an account to comment. Please register or login here!