Hi,
This is an MS Access 97 question.
I have developed an Access application with Oracle tables as back-end. I have linked Oracle tables using a DSN. (created DSN using ODBC administrator) There is only 1 form in this application.
When I run the form it runs fine and does updates, inserts and deletes the records from the oracle tables fine.
But when I run the form second time, it gives MSAccess.exe error. I am making sure that the recordsets are closed and set to nothing . But I do not know why it does like this.
rst_table.close
set rst_table = nothing
could someone give me some suggestion to avoid this memory error please. Its very urgent..
thank you
nath
This is an MS Access 97 question.
I have developed an Access application with Oracle tables as back-end. I have linked Oracle tables using a DSN. (created DSN using ODBC administrator) There is only 1 form in this application.
When I run the form it runs fine and does updates, inserts and deletes the records from the oracle tables fine.
But when I run the form second time, it gives MSAccess.exe error. I am making sure that the recordsets are closed and set to nothing . But I do not know why it does like this.
rst_table.close
set rst_table = nothing
could someone give me some suggestion to avoid this memory error please. Its very urgent..
thank you
nath
