Updating remote sql database with dbase

The changes that you make to data in one place are reflected in the other.

However, if you want to make structural changes, such as removing or changing a column, you must do so from within the SQL Server database, or from within an Access project that is connected to that database.

To update a linked table by applying the latest SQL Server object structure: Because Access data types differ from SQL Server data types, Access must determine the most appropriate Access data type to use for each column of each SQL Server table or view that you import or link to.

For example, a SQL Server column of the data type bit is imported or linked into Access with the data type Yes/No.

You can change the data types of fields in imported tables; however, you cannot change the data types of fields in linked tables, except in the SQL Server database or in an Access project that is connected to that database.

Comments