Handling Inserts and Updates to Remote Data

When a user inserts a record into a remote table, Microsoft Jet sends values for every field in the recordset to the remote database. Similarly, when a user updates records in the remote database, the engine sends the values that changed during the update.

You should be aware of three special cases when using Microsoft Jet to insert or update remote data:

• If the remote database server supplies default values when you insert a new record, Microsoft Jet honors those defaults. You can override these values if needed. Microsoft Jet uses the server defaults only when no value is specified.
  
  
• If the remote database contains a trigger that is set to activate when a user changes data in a specific field, the trigger will not be invoked unless the user has changed the data in that field. When Microsoft Jet updates a record, it does not provide values for every field; it only provides values for the fields that have changed.
  
  
• Microsoft Jet does not overwrite the data in a field that the ODBC API SQLSpecialColumns identifies as a SQL_ROWVER. These values are generated and maintained by the remote database server, and Microsoft Jet does not allow you to modify these fields.