MEMORY PROBLEM

Hi all,
I am getting an error message in MS-ACCESS. When I am trying to run my application developed using VBA I get an Error message "Out of Memory 2001" Can any body help me why this occur. Also this does not occur always it happens after the application runs continously for some days. As my app should run all the time I could see this as a bug in MS-ACCESS. Can any one clarify this.
Thanks

Srini

It looks like you forget to close database objects when you don't need them anymore. If you open recordset with OpenRecordset method it's good idea to close it with Close method and set to Nothing. Do you do this? If yes, I'm sorry.
Vlad

Thanks for that info. I did closed all the database objects and set them to nothing. What else could be the problem ? Its strange thing that it occurs after 3-4 days after running the app continously.

Thanks any how for the help.

Srini

Are you using arrays? (redim them to 0 when you don't use them)

Crazy D @ Work :-)

No, I am using DAO. I am using many database objects. I am closing and setting them to nothing.

Srini