README
------

If when you try to export a job to WebTRIM you see an error like the following...

2020-02-12 00:40:32 odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application, SQL state IM014 in SQLConnect_

This can be resolved by downloading a Microsoft Access Database Engine from the following URL:
https://www.microsoft.com/en-US/download/details.aspx?id=13255

The solution above was found here:
https://stackoverflow.com/questions/18751308/odbc-connection-to-access-database-in-64-bit-windows


Descriptions of AQ .mdb databases
---------------------------------
Database AQMatLst  contains table FullMatList which has an Est_no column, and contains one row per material item.
Database AQMatLst  contains table MatList     which has an Est_no column, and often (perhaps always) no rows.
Database AQMatLst  contains table PMRate      which has NO Est_no column, and often (perhaps always) no rows.
Database AQPartLog contains table PartLog     which has an Est_no column, and contains one row per parts order.
Database AqInvEst  contains table EstInv      which has an Est_no column, and contains one row per invoice.
Database AqNotes   contains table AqNotes     which has an Est_no column, and contains one row per note.
Database aqqte     contains table OVD         which has an Est_no column, and contains one row per quote.
Database aqqtet    contains table Qtet        which has an Est_no column, and contains one row per quoted item.