"Out Of Memory"

[PeteCresswell]

I've got a very complicated process (complicated to me, at least....)
that clearly has some problems as evidenced by weird UI behavior.

But it does run to completion and the numbers coming out of it do seem
correct.

However when I go into a VBA code window afterwards and try to copy
some code, somebody pops an "Out Of Memory" dialog.

I ran the list in the Help file and didn't find anything. i.e. my C:
drive has plenty of space on it, I don't have any more "Public"
variables that I did before the process, and so-forth.

I'm wondering if "Out Of Memory" could be a clue that would help me
localize whatever issues I have in the aforementioned routine.

Anybody have thoughts on this?

 

[PeteCresswell]

I'm also seeing "The Windows clip board cannot be used. Perhaps it is
locked by another application." from MZ-Tools when I open a code
module.

I tried compacting/repairing/re-starting and MZ-Tools' message
persists.

I expect a re-boot to clear it all up - but I'm still back to
wondering if my problem process is a player and, if so, how.

 

[Paul Shapiro]

Whenever I've gotten the out of memory error, it's been caused by a
corrupted Access object. The specific error message has not been
particularly helpful.

Does your complicated process intentionally interact with the clipboard?

You could try running individual stages of the complicated process, to see
if you can narrow down the part of the process responsible for the
corruption. If you can't separate the process into independent pieces, you
could start by running just the first half of the process. If that fails,
try the first quarter, etc. If it succeeds try the first 3/4. Since the
process itself doesn't throw the error, you'll have to try one of your other
error indicators.

I'm also seeing "The Windows clip board cannot be used. Perhaps it is
locked by another application." from MZ-Tools when I open a code
module.

I tried compacting/repairing/re-starting and MZ-Tools' message
persists.

I expect a re-boot to clear it all up - but I'm still back to
wondering if my problem process is a player and, if so, how.

---Original Message---
I've got a very complicated process (complicated to me, at least....)
that clearly has some problems as evidenced by weird UI behavior.

But it does run to completion and the numbers coming out of it do seem
correct.

However when I go into a VBA code window afterwards and try to copy
some code, somebody pops an "Out Of Memory" dialog.

I ran the list in the Help file and didn't find anything. i.e. my C:
drive has plenty of space on it, I don't have any more "Public"
variables that I did before the process, and so-forth.

I'm wondering if "Out Of Memory" could be a clue that would help me
localize whatever issues I have in the aforementioned routine.

 

[Tony Toews [MVP]]

However when I go into a VBA code window afterwards and try to copy
some code, somebody pops an "Out Of Memory" dialog.

That's the default message when Access is having troubles but doesn't
know what else to say.

Standard items to try are decompiling, importing to new MDB, different
printer driver, updated video driver and rebooting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/