Speed up ODBC - How?

J

James

Connecting Access to Attache database via ODBC.

Ideally it would be a "live" connection but as a trade off it would probably
work if I could refresh the access table containing the data I am getting
via ODBC on a regular basis.

Q: How would I automate the update process?

Q: Is there any way to speed up accessing the table in the Attache Database
through MS Access?


T.I.A.
 
V

Van T. Dinh

AFAIK, the connection cannot be "live" since the Attache ODBC-driver is
"Read-Only". Besides, if you look into the Attache Tables, you will see
lots of Fields that actually store calculated values (I think this is fairly
normal practice for accounting packages).

Also, the Attache ODBC driver (it is actually an C-Tree ODBC driver with an
Attache Data Dictionary file) often behaves weirdly when you use the
DatasheetView of the ODBC-linked Tables and show lots of "#Deleted" values.
You need to use Queries to access the data correctly, even some thing like:

SELECT *
FROM CUSTOMER_MASTER

to get the correct data from the CUSTOMER_MASTER.

* Q1: Personally, to update the CUSTOMER_MASTER data stored in Access but
originally from Attache, I simply delete the old Table and create a new
Table using the Make-Table Query. I normally do this after the
"End-of-Month" processing to get the accurate "30DAYS", "60DAYS" and
"90DAYS" values.

* Q2: Store data in Access.

In my case, we only need Attache data for monthly Reports. The client does
not want to pay AUS$250.00 *per* ODBC license to Attache (Australia) - the
general C-Tree ODBC license can be bought for about US$150.00 per 5-license
pack so we only bought 2 licenses (1 on the back-up PC). Thus, I do monthly
update so that they can access the Report whenever they want.
 
Top