Note: If both the Insert and Update options are checked, the Access Adapter checks whether an SQL Update or Insert should be generated in each instance, by reference to the Primary Key.
Tip: If you are certain there is only data to insert then avoid checking the Update option, as this will make the process significantly faster.
This information is only required on the WRITE side.
No changes are needed here generally, since the correct information is usually obtained directly from the schema.
If on your system there is an MS Office or Access installed then you need to use exactly the same Flow Heater variant (32-bit or 64-bit) as your Office/Access installed: For a 64-bit Office/Access installation you require the 64-bit Flow Heater variant, conversely for a 32-bit Office/Access installation you need the 32-bit Flow Heater variant, even when you are using a 64-bit operating system!Which variant you have to use depends on your system prerequisites.In principle, Flow Heater does not require an MS Office/Access installation in order to work with Access databases.A Primary Key field is used in an Update to identify record that possibly exists.Auto Increment fields are neither assigned nor amended in Insert/Update statements.