A long winded problem.
I am running a stored procedure that gathers data into a temporary table and then runs an update cursor on the table to provide a running total on the transactions.
The stored procedure accepts three variables to determine the account to process and which details are required.
When the SP is run from TSQL the returned results are as expected. When run from a passthrough query in Access97/ODBC the values are incorrect.
If a number of clients access the same account then one of the clients will return the correct result.
The error that occurs does not occur for all client accounts selected and the accounts that are affected appear to have nothing in common that could be causing this.
I am pulling my hair out over this.
any suggestions would be greatly appreciated
Thanks
Nigel