EddStewart
Programmer
Hi,
I'm trying to write a program which will access sales and purchase invoices in Sage Line 50 v7 and then do simple calculations on this data to find how much stock is required to be ordered etc. I'm using Access '97 to do this but i've run into some difficulties with its speed over ODBC.
The data is accessed via a set of linked tables however when trying and do any work on it, it takes forever. So I created a set of temporary tables and then wrote a simple macro to copy it over but the copy routine works one field at a time resulting in it taking just as long.
Therefore does anyone have any ideas as to how to speed it up? or explanations as to what I am doing wrong?.
Thankyou very much,
Edd Stewart
I'm trying to write a program which will access sales and purchase invoices in Sage Line 50 v7 and then do simple calculations on this data to find how much stock is required to be ordered etc. I'm using Access '97 to do this but i've run into some difficulties with its speed over ODBC.
The data is accessed via a set of linked tables however when trying and do any work on it, it takes forever. So I created a set of temporary tables and then wrote a simple macro to copy it over but the copy routine works one field at a time resulting in it taking just as long.
Therefore does anyone have any ideas as to how to speed it up? or explanations as to what I am doing wrong?.
Thankyou very much,
Edd Stewart