No Access DB 2010 (*.accdb) access from TOS 6.3

[ThomasPit]

Hi
I have problem to access MS-Access 2010 Database (*.accdb). Accessing older MS-Access DB (*.mdb) works fine.
When I try to access MS-Access 2010 Database (*.accdb) I get the following error:

  java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: NULL
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.runWithCancel(DatabaseForm.java:3812)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$59.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)

OS:      Windows Server 2010
Talend: 6.3.0 (TOS_DI-win-x86_64)
Java:    java.version=1.8.0_111



Any idee?

Thomas

[ThomasPit]

Hi
Up to now I didn't get any suggestion/Solution on my problem.
Is the answer to hard or are there no solutions?

Please help.
Thomas

[_AnonymousUser]

Hi Thomas,
Instead of leaving the user and password fields empty, you can try to enter an empty string: ""
Best regards
Olivier