Attend Excelapalooza
Thanks Thanks:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Access Database Won't Open - NO Error Messages

  1. #1
    Board Regular
    Join Date
    Sep 2006
    Posts
    120
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Access Database Won't Open - NO Error Messages

    Hi,

    We have been using an Access database at work with no problems at all....today we tried to open the database (the file is still showing exactly the same) on opening it opens Access but then nothing happens...there are no error messages to suggest anything it just simply does not open??

    Does anyone have any advice on what we can do? I have tried a number of things to rectify it but whatever I try it acts like the file is not there (even though it shows it in windows explorer).

    Any help would be so appreciated :O)

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    73,626
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    Open up Access and create a blank database.

    Goto File>Get external data>Import...

    Locate the problem file and see if you can import the tables/reports etc.

    If you can do so, then close the newly created database and see if that opens normally.

    If it does then it could be the original file has become corrupted.

    You might be able to repair it if you goto Tools>Database Utilities>Compact and repair... when you open Access on its own.
    If posting code please use code tags.

  3. #3
    Board Regular
    Join Date
    Sep 2006
    Posts
    120
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    Hi - I've already tried both those options and on both it lets me navigate to the file but then when choose the file the prompt disappears and I'm back with an empty Access screen??

  4. #4
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    73,626
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    What prompt are you referring to?
    If posting code please use code tags.

  5. #5
    Board Regular
    Join Date
    Sep 2006
    Posts
    120
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    If I open MS Access and go to Tools > Database Utilities > Compact and Repair .... it lets me navigate to the file but when I choose the file nothing happens and I'm left with a blank access screen.

    Likewise if I create a new blank database and go to File > Get External Data > Import Data it lets me navigate to the file but when I select it nothing happens again....?

  6. #6
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    15,863
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    I hesitate to say so but this sounds serious! Did you have any further luck? There are access recovery specialists you can find on the web - software and/or services. Try using another program to access the file too, if possible, besides your local access application. If/when you recover, be sure to run a thorough set of pc maintenance routines - full virus scan, check disk for errors, defragment, check for updates at Microsoft, and implement a backup strategy. Consider the age of your pc - disks don't last forever.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  7. #7
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,964
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    Have you tried rebooting your computer?
    Bob Larson
    Former Access MVP (2008-2010, 2011)

  8. #8
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    15,863
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    Thanks for the reality check Bob! That's always where I start...

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  9. #9
    New Member
    Join Date
    Jun 2010
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    Hi,
    Did you find a solution to this problem? I am having the same problem now. Cant find anything about it. It seems not many people have this problem. Its rare.

    I have tried all the tricks mentioned above. None seem to work.
    I need to know if there is a solution to this one.


  10. #10
    Board Regular Marbles's Avatar
    Join Date
    Feb 2005
    Posts
    616
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Access Database Won't Open - NO Error Messages

    Have you tried opening while holding down the shift key?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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