ODBC--Connection to 'accessODBC' failed.

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sakanet
    New Member
    • Apr 2008
    • 3
    #1

    ODBC--Connection to 'accessODBC' failed.

    Hi,

    I have a file "filename.m db" i am trying to open this with MS Access 2003 and I get the error message: ODBC--Connection to 'accessODBC' failed.

    Unfortunately I have no knowledge about how databases work. I was told that I needed to have the driver Microsoft ODBC for Oracle, which I already have.

    Please help, i wasted so much time already trying to figure this out with zero database experience.

    Thank you very much.
    Tags: None
    • Scott Price
      Recognized Expert Top Contributor
      • Jul 2007
      • 1384
      #2
      A little more information is needed!

      You say that the file is of type .mdb? And trying to open this from within MS Access 2003 produces this error?

      Where does the Oracle reference come from?

      Regards,
      Scott

        Comment

        • sakanet
          New Member
          • Apr 2008
          • 3
          #3
          Basically this is one 76 MB size of mdb file. When I click on the file it opens it in Access and I see different records on the right pane, I click on any of them and get this error message, ODBC--Connection to 'accessODBC' failed.
          I am not sure but maybe this database was created with Oracle and Access is not able to open/view it because it doesn’t have the right ODBC. I am not sure even if this makes sense to you.

          Thanks for trying to help. If you don't have any answer I understand since i am not able to give you enough details.

            Comment

            • Scott Price
              Recognized Expert Top Contributor
              • Jul 2007
              • 1384
              #4
              If it's an mdb file the GUI (graphical user interface) part was created in Access.

              Knowing what you mention to me now, I suspect you have a two section database, also known as 'front-end' and 'back-end'. The 'front-end' is the GUI part and contains the forms, queries, reports, etc that the user sees. The 'back-end' holds the tables and data. The back-end could easily have been created in Oracle.

              It sounds to me like the link between your front end and back end has become invalid, either by a renamed or relocated back-end file or by some other means.

              The first thing I would do is try to verify what the back-end file is named, and where it is located. Any changes need to be changed back, or the mdb file needs to be updated to reflect the current scheme.

              Regards,
              Scott

                Comment

                • sakanet
                  New Member
                  • Apr 2008
                  • 3
                  #5
                  Scott, thank you. We'll have an expert soon to look at it. I will try to post the solution here. Thanks again.

                    Comment

                    Previous template Next
                    Working...