memory overflow errors 3

[jordanking]

Hello,

I am using VBA in access 2003.

I have a lengthy procedure that makes calls to several functions defined in seperate modules. Does the memory space used by the external function's variables get freeed once the call to the function is complete? Or do I need to manually release the vraibles memory space usage once the procedure is finished with them?

 

[TonyJollans]

After posting that I didn't know, I realised that I was actually using just such a typedef at the time (converting a Long to a Byte array) - funny how you sometimes do things without realising what you're doing and it takes a jolt to make you take a step back and learn the lesson; thank you, Mike.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[ESquared]

I was not remembering the 4-byte boundary thing, although it seems vaguely familiar now.

In any case, checking the length of the type would have brought up that issue, right?

 

[strongm]

Depends whether Len or LenB was used ...

 

[ESquared]

Oh I see... use the LenB function to see if UDT members are being aligned (have any padding inserted between them)...

 

[strongm]

More-or-less, yes.

 

[ESquared]

Of course, I had to spend nearly an hour delving into this, and didn't see your post of 12:32 until much later. But now I know.