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


      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