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:

• a database engine. This comes standard on all Windows PCs
• a query and development environment. This is what you get when you purchase MS Access

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

• What MS Access calls a Query is called a View in AQT.
• AQT is unable to show you the definition of your Access queries. These are held internally in a way that AQT is unable to get at.
• Within MS Access, you can define parameters within a query. For instance you can define a query as:

  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.

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.