Very Computer

by **Waleed Kamou** » Wed, 19 Dec 2001 16:24:16

Hello everyone,
I am currently facing a problem that makes MS Access XP remain resident in
memory;
In fact, when programing with ADO, and then close or exit from Access, I am
not able to restart Access unless I press the ctrl-alt-delete and remove MS
Access from memory.
Can anyone help?

Thanks in advance

Walid Kamouh

by **Joe Fallo** » Thu, 20 Dec 2001 08:41:34

This is usually related to one of two problems in your code.
Set rs = Nothing may be missing from your code. (Or some other object
variable is not being destroyed.)

The other is using implicit code for Boolean variables.
e.g. If fVarName Then

You should be explicit:
If fVarName = True Then
--
Joe Fallon
Access MVP

Quote:> Hello everyone,
> I am currently facing a problem that makes MS Access XP remain resident in
> memory;
> In fact, when programing with ADO, and then close or exit from Access, I
am
> not able to restart Access unless I press the ctrl-alt-delete and remove
MS
> Access from memory.
> Can anyone help?

> Thanks in advance

> Walid Kamouh

by **Waleed Kamou** » Fri, 21 Dec 2001 16:06:15

thanks

> This is usually related to one of two problems in your code.
> Set rs = Nothing may be missing from your code. (Or some other object
> variable is not being destroyed.)

> The other is using implicit code for Boolean variables.
> e.g. If fVarName Then

> You should be explicit:
> If fVarName = True Then
> --
> Joe Fallon
> Access MVP

> > Hello everyone,
> > I am currently facing a problem that makes MS Access XP remain resident
in
> > memory;
> > In fact, when programing with ADO, and then close or exit from Access, I
> am
> > not able to restart Access unless I press the ctrl-alt-delete and remove
> MS
> > Access from memory.
> > Can anyone help?

> > Thanks in advance

> > Walid Kamouh

Very Computer

Access remains resident in Memory

Access remains resident in Memory

Access remains resident in Memory

Access remains resident in Memory