Transaction mode issues
MS Access doesn't fully support transaction mode. This will cause problems in the following areas:
- if you use Transaction mode
- if you set Safe Update mode on
- if you deselect Options > Technical Parameters > Auto commit
- in the Data Loader if you change Commit options to anything other than Every row