Previous Topic

Next Topic

Book Contents

Book Index

MS Access

You don't need MS Access to read Access databases with AQT

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.

Access Queries

Transaction

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.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.