memory problems???

[VickyWinters]

Hi

I am not a programmer but I need some help on this issue....

I get messages that I am out of memory.

From what I read....access works on 68k blocks of memory. Even if I have 256k....it still functions on 68k....so I get these message that I am out of memory, which I am not.

If I restart my computer....then it is OK only for a while...but the problem reoccurs after using it again.

How do I allocate more memory to my database so I do not have this problem??? Please keep in mind I am not a programmer so detail info is appreciated.

thanks
vicy

 

[danvlas]

I think you have set some Object variables within your application and have not reset them after they were not needed anymore. The golden rule:
Whenever you

Set Something = Whatever.Object

make sure at the end you

Set Something = Nothing

Even with Recordsets...

Good luck
Daniel Vlas
Systems Consultant