The following table compares SQL Server and Access data types.
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.