Results 1 to 6 of 6
  1. #1
    Sonu is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    35

    MS Access DB does not open

    Hello All,




    This might be a common issue, but I am not able to fix it.


    I am trying to open an Access database from a folder path and it throws the below error:


    "Microsoft Access can't find the database file '<DB Path Here>'. Make sure you entered the correct path and file name."


    The database file is not a shortcut and the DB does exists. Not sure if this could be a permission issue, as I am able to create a Notepad (txt) file and save changes to it at the same location.

    Thank you,

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Possibly corruption. Try decompiling the database http://www.fmsinc.com/microsoftacces.../Decompile.asp
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I could be corruption, tho I've never seen that message for a file that does exist.
    And you are sure its a file you've opened before, because you could get that error if you are trying to open a db made from a newer version of Access, in an older version of access. (open a 2016 db using Access 2010)?

    you dbl-clicked the file and it failed?
    you opened access from the access startup icon, THEN menu: file, open the db?

    if both fail, and both access and the db file are in the same version, the it is corruption. Hope you have a backup.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I don't think its a version issue.
    If you try to open a A97 file or earlier in A2013 or later, you will get a different message about file formats.
    Similarly if you try to use e.g. A2010 to open e.g. a A2016 file with support for bigint datatype, it will fail with a message about the minimum version needed for that file.

    Which comes back to likely corruption.
    If its corrupted code, decompiling should fix it.
    If corrupted data, then try importing all objects into a new blank database...if it allows that
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Sonu is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    35
    It is not a version issue. Also by opening with a double click or open access>file>open, I got the same error.

    I tried to decompile, and after selecting the database (to decompile), I got a permission error: "You don't have permission to open this file. Contact the file owner or an administrator to obtain permission."

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Next try importing all objects into a new database.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 12-06-2016, 11:28 AM
  2. Replies: 2
    Last Post: 06-25-2014, 10:29 PM
  3. Replies: 12
    Last Post: 07-25-2013, 12:49 PM
  4. Replies: 11
    Last Post: 08-29-2012, 11:00 AM
  5. Replies: 1
    Last Post: 06-04-2009, 07:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums