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

  • Thread starter Thread starter Luis Marques
  • Start date Start date
L

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.
 
Luis Marques said:
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.
Click to expand...


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.
 
It happens with all databases, even the simple ones (with just one table, for
instance).

"Dirk Goldgar" escreveu:
 
Luis Marques said:
It happens with all databases, even the simple ones (with just one table,
for
instance).
Click to expand...


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.
 
Back
Top