Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Hidden Instance of Access (2002)

    Hello, I have tried to remove a hidden instance of access, however I am having difficulty with it. I tried the post that HANS has put with using Word to open the VBA window and "GetObject.... " I keep getting an error message saying: Run Time error "-2147467259 (800004005)': Microsoft Access can't open the database because it is missing, or opened exclusively by another user" It is not open by anyone... ANY HELP!!!!

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

    Re: Hidden Instance of Access (2002)

    I have one site where users frequently get another instance of Access running on their machines. It can only be seen as a Process in Task Manager, which is where we delete it. I don't know how it gets created.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hidden Instance of Access (2002)

    Oh dear sounds like a corrupt database, have you tried a compact and repair

    Tools | Database utilities | Compact and Repair database


    Does that help
    Jerry

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

    Re: Hidden Instance of Access (2002)

    If you cannot use the method from <post:=542,112>post 542,112</post:>, try a more radical approach:
    - Start the Task Manager (Ctrl+Shift+Esc)
    - Activate the Processes tab.
    - Select a line with MSAccess.exe.
    - Click End Process and confirm. (Closing Access may take a while)
    - Repeat if there were more instances of MSAccess.exe.

  5. #5
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Hidden Instance of Access (2002)

    Thank you so much for your help... That was easier than I thought...

Posting Permissions

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