Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memory Error..(MSAccess.exe) - Application error

Status
Not open for further replies.
bnath001

bnath001

Programmer
Aug 18, 2000
100
US
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
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
424
Axworthy
Axworthy
Modex
  • Locked
  • Question
How to Close Desktop Application Windows using VBA
Replies
3
Views
369
Andrzejek
Andrzejek
DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
319
DB_Bowes
DB_Bowes
bosk0
  • Locked
  • Question
Getting a syntax error in INSERT INTO statement 1
Replies
5
Views
342
Andrzejek
Andrzejek
iamchemist
  • Locked
  • Question
"Access Application Not Responding" Message
Replies
1
Views
215
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top