Variables not resetting on DB close

[chanson]

I have been running into this weird problem on a database that I have been working on where when I close the database it doesn't always release all of the variables. It doesn't make any sense to me, nor does it seem possible but it is happening. Has anyone experienced anything like this before? What did you do to fix it?

Thanks

 

[WayneRyan]

c,

Doesn't make sense to me either.

What variables are retaining values? Global variables? Form controls?

Any code setting values? Might just look like they're being retained.

Need more info.

Wayne

 

[Surjer]

The only way I can see this happening is in using Automation and your not setting the application free.

like

Dim X as object
set x = createObject ("Access.Application.8")

and then it crashes at some point so x never gets set to nothing. This would leave access running in the background...

 

[chanson]

nm, I'm stupid. It was being reset in a section of code that I ignored.