Please help with bogging down

[Lisa]

Hi.
I am running Access 2000 and am trying to use code instead
of macros for my automation.
I have debugged, decompiled, and compacted - however, it
takes a VERY long time to open or go into design view of
my forms with code attached.
Also, as I work in the VBE editor for a while, my system
resources go way down to like 10% or 20% and I have 256 mb
of ram.
Can anyone please provide any advise?
Thanks
Lisa

 

[PC Datasheet]

Are you opening any objects like:
Set Db = CurrentDB()
Set Rst = DAO.Recordset
Rst = Db.OpenRecorset("MyTable")
Set XL = CreateObject("Excel.Application")

Recordsets need to be closed and set to Nothing and other objects need to be set
to Nothing at the end of subroutines and functions. If you don't and are doing
this multiple times, you will quickly eat up your resources.

 

[Lisa]

Hi.
Yes, I am creating querydef's opening recordsets etc. But
I am doing a rec.close at the end, is that enough?
That's what my Beginning Access 2000 vba book says to do.

But When I'm working in code my system resources go down
to 15 to 20% and I have 256 mb of ram - it sure seems like
something is going wrong, doesn't it.

I hope you're still around!
Thanks
Lisa