I am making a client MS-Access application (ver 2.0),
whith attached ORACLE tables (through ODBC). At a certain
point in my application I have to process a lot of records.
Therefore I open a recordset (from an attached Oracle table),
which contains approximately 1000 records (in the future this
will be even more records). All these records have to be checked
and updated. After a while (after a lot of records have been processed) I
get the error: 'ODBC-update failed on attached table; Not all
variables bound; Memory allocation error'.
Whatever I do next, the message 'ODBC-call failed: memory allocation error'
keeps showing up.
I hope somebody can help me with this problem.
Before I have been processing a smaller amount of records (say 50 records),
and I never had any problems.
Esther Salk
--