Access Size follow up problem -- what is Error # 0?

[KHerm]

Wasn't sure whether to start another thread or not. I'm getting an Error # 0 when I run the module that quit because the Access database got to 1 gig.

I'm using this code to capture the error:

Msg = "Error # " & Str(Err.Number) & " was generated by " _
& Err.Source & Chr(13) & Err.Description
MsgBox Msg, , "Error", Err.HelpFile, Err.HelpContext

The message box that pops up with Error # 0 has a help button that gives the error that there is not enough memory to handle the request.

Could that be what error #0 is?

This module has always run before. I am at my wits end on getting it running again.

Would creating a new database and copying in the modules and queries, and relink tables get me anywhere?

Thanks for any help....

Ken

 

[PaulF]

did you place an exit sub or exit function command prior to the error handler?..... if not the message will always appear, even if no error occured.

PaulF

 

[ghubbell]

Hi Ken,
Although making a fresh db probably wouldn't hurt, maybe you have a loop going in that module that is taking all the memory your computer has? Could you post the problem module/function? Gord
ghubbell@total.net

 

[KHerm]

To Paul: Yes. I have the error trapped right, I guess I could have put in more code to make that clear.

To Gord: Well, I went ahead and made a fresh database, and the process is continuing, as it used to, now.

The function is quite large, and is code that was written for this company quite awhile ago and has been working. Unfortunately I can't post it. I've been watching the memory and it does require a lot, but it has been releasing it, too.

We'll know soon if the new database will work all the way through.

I do thank you for your help!

Ken