Results 1 to 14 of 14
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Phantom Access Instance (Access2000)

    Has this happened to anyone else? You double-click on a .mdb file in Windows Explorer and nothing happens. If you open Windows Task Manager and look on Processes tab, there is an instance of Access running; but there is no entry on the Applications tab in Task Manager, nor is there anything on the Windows TaskBar. If you delete this process, you can open the .mdb with no problems. It is as if the last instance of Access didn't properly close.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Phantom Access Instance (Access2000)

    The invisible instance is probably left over from a previous session. Possible causes:
    a) You started an instance of Access using Automation. This instance failed to be closed properly.
    or
    [img]/forums/images/smilies/cool.gif[/img] During the previous Access session, an object hasn't been set to nothing (in particular, an ADO or DAO object).

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Phantom Access Instance (Access2000)

    I know that it wasn't because of opening Access via Automation.

    I suppose it could be because I missed setting an object to nothing, although I'm usually pretty good at doing that. Thing is, I can't discern a pattern for when it happens.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Phantom Access Instance (Access2000)

    It can be pretty tough to discover the exact cause of problems like this. You might keep Task Manager open, and check the Processes tab before opening a database and after closing it.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Phantom Access Instance (Access2000)

    I've run into this many times, Mark. One culprit that often gets overlooked is code that treats the value of a checkbox or toggle button as an implicit boolean, like <pre>If Me.chkWhatever Then</pre>

    . If you use a naming convention for controls, you can search through all instances of "If Me.chk" and make sure all those conditions are written like this: <pre>If Me.chkWhatever = True Then</pre>

    Charlotte

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Phantom Access Instance (Access2000)

    I think I'm getting a headache! I thought that the "if chkbox then" was the preferred method, for some reason I can't remember. I assume, then, that this also applies when using IIF; so rather than IIF(chkBox,...,...), you should use IIF(chkBox = True, ..., ...)?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Phantom Access Instance (Access2000)

    Definitely. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Charlotte

  8. #8
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Phantom Access Instance (Access2000)

    Never in Access however same symptom happens often in Outlook 2000 without knowing why, just an annoyance, once I End Task on Outlook.exe, desired instance of OL opens.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Phantom Access Instance (Access2000)

    Do you use Word as mail editor in Outlook?

  10. #10
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Phantom Access Instance (Access2000)

    Yes I do

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Phantom Access Instance (Access2000)

    That's probably the explanation. All kinds of strange things happen if you use Word as mail editor. At the moment, you can still choose not to, unfortunately, we'll all be forced to use Word as mail editor in Office 2007. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  12. #12
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Phantom Access Instance (Access2000)

    Thanks for the explanation, its worth the annoyance once in a while to continue using Word

    John

  13. #13
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Phantom Access Instance (Access2000)

    "unfortunately, we'll all be forced to use Word as mail editor in Office 2007"
    __________________________________

    Is this only if you use Outlook, or do they have a way of forcing all of us to do it?
    Regards
    John



  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Phantom Access Instance (Access2000)

    I meant in Outlook. It doesn't apply if you use another mail client, such as Thunderbird.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •