Bloating & temp recordsets??

[connexion]

I have just been working with some temporary recordsets in access 2000.

After working with the recrodsets each is closed and set to nothing but this leads to bloating of around 20Mb on a 70Mb backend database.

So I (in messing around) I added "DoEvents" after closing each temporary recordset and the bloating reduced to just 8Kb.

Is it normal practice to force the closure of temporary recordsets before moving to the next step using DoEvents, because this certainly seems to be suggested by this result?

Vince

 

[gemma-the-husky]

doevents wouldn't have any effect i dont think. doevents just lets an app continue to process events in multiple procedures.

 

[connexion]

Whoops!

Yeah, you're right.

The whole things so complicated i missed that fact that a previous run had already deleted the records being removed.

So no bloat because no matching records founds!

:-(