When I quit out of Access I cannot load Access back in

[Luis Marques]

I've only noticed this with Access 2003. When I quit out of Access I cannot
load Access back in. Instead I have to bring up the task list (Ctrl Alt Del)
and remove the still running Access task. Then it loads it back in fine.

I have been using Access 2002 on the same machine (before upgrading) and
have never had the problem before. I have been using Access since 97 and
never has this issue before.

 

[Dirk Goldgar]

I've only noticed this with Access 2003. When I quit out of Access I
cannot
load Access back in. Instead I have to bring up the task list (Ctrl Alt
Del)
and remove the still running Access task. Then it loads it back in fine.

I have been using Access 2002 on the same machine (before upgrading) and
have never had the problem before. I have been using Access since 97 and
never has this issue before.

Does this happen with one particular database, or with all databases? The
most common cause of this that I have seen is having a static or
module-level object variable that is not set to Nothing. Do you use any
global recordset or database objects in your VBA code?

There was also a bug in Access 97 where an implicit VBA reference to the
value of a check box would cause this. Specifically, a line of code like
this:

If Me!chkMyCheckbox Then

.... would cause the problem. Other forms of the statement that are
logically equivalent, like these:

If Me!chkMyCheckbox.Value Then
If Me!chkMyCheckbox = True Then
If (Me!chkMyCheckbox) Then

.... would not. But I believe that was fixed a long time ago.

 

[Luis Marques]

It happens with all databases, even the simple ones (with just one table, for
instance).

"Dirk Goldgar" escreveu:

 

[Dirk Goldgar]

It happens with all databases, even the simple ones (with just one table,
for
instance).

Even if there is no VBA code or macros? Do you use any add-ins? Have you
made any modifications to your installation of Access?

I've never heard of this problem unrelated to the issues I mentioned, and
would suspect that your Access installation is damaged in some way. If
there's nothing you know to be exceptional about your installation, I would
try to repair or reinstall Access and/or MS Office.