Not able to use MS Access database through Netbeans

[andrew ronchi]

I am creating sample desktop application using netbeans and I am using Ms Access as database. I have created datasource as accessdb and with database name as info.accdb. But while creating connection netbeans is able to connect to db but not able to fetch schema. Database url I am giving is "jdbc:odbc:accessdb". It is giving error as "Unable to fetch schema. Insufficient Information to establish a connection to obtain list of schema. Check url, username and password ". I have not mentioned any username and password there. Because I dont have any. It is showing connection established but not showing any schema there. How to connect to ms access db?? I am using Netbeans 6.0

[Maneesh Godbole]

This would be more suitable on the IDE forums.
Moving....

Regarding your question, perhaps this might help http://wiki.netbeans.org/ConnectingToMsAccessDB

[Maneesh Godbole]

Also check if this affects you
https://netbeans.org/bugzilla/show_bug.cgi?id=86831

[andrew ronchi]

I solved it. First I created project connecting to mysql. Then I manually added url for ms access.