My problem is linking to foxpro tables using ODBC. Started doing some financial reports, and problem is each time the report is run I get different figures.
I am using a combination of access/vb6 to generate the reports.
Just by doing a simple select sum([customer_share]) on table even this brings back different figures.
I have tried mdac 2.5,2.6,2.7,2.8.
I am using XP (service pack 2)
microsoft office (proffesional (access 2000))
All these have the latest drivers.
I am using free table connection with background fetch disabled.
this is getting very worrying as the dbf tables contain all the financial data.
I am using a combination of access/vb6 to generate the reports.
Just by doing a simple select sum([customer_share]) on table even this brings back different figures.
I have tried mdac 2.5,2.6,2.7,2.8.
I am using XP (service pack 2)
microsoft office (proffesional (access 2000))
All these have the latest drivers.
I am using free table connection with background fetch disabled.
this is getting very worrying as the dbf tables contain all the financial data.