1 Reply Latest reply: Dec 18, 2013 9:26 AM by Jim Smith RSS

    How to use Oracle SQL Developer 4.0 to connect to Ms Access file with .accdb extension

    94f47525-4e3c-46ad-8244-f6a48153f074

      Hi all,

       

      I am using Oracle SQL Developer 4.0 and Ms Access 2013 under Windows 7 (64 bits)

       

      After browsing and selecting MS Access file with accdb extention, I got  an error message  :[Microsoft] " Data source name not found and no default driver specified".

       

      On Administravitve Tools=> ODBC Data Source Administrator=>Drivers I have                                                File                                date

      Name :                                                                               Version

       

      Microsoft Acess Driver (*.mdb, *accdb)                                 12.00.4518.1014                                        ACEODBC.DLL                    26/10/2006

       

      Would you please advise?

       

      Thank you very much in advance