To understand this, you need to realise that MS Access consists of two separate components:
If you do not have MS Access on your machine, you still have the database engine. As a result, AQT is able to read and update your Access databases.
select * from customers where customer_code = custcode
When you run this query, MS Access will prompt you for the value of custcode. However the use of such parameters is internal to MS Access; if you try to run a query which is defined in this way to AQT you will get the message Too few parameters.
MS Access has limited support for transactions. If you are running in Transaction Mode, or are using Safe Update Mode you can get message Invalid Transaction State, Function Sequence Error or Attribute cannot be set now.
In the Data Loader, you will get similar errors if you use a Commit Frequency other than Every Row.