Database toolbox: username and password problem

I need the database toolbox to run queries in Access using matlab: I tried:\ 1. querybuilder (the visual query builder shows up)then: 2. I double clicked "MS access database" . A window with a :username and password shows up although none of my Access databases is password protected I tried everything (including empty username and password " to proceed without success. Any help is greatly appreciated

Answer 1

[Chirag Gupta]

Have you set up an ODBC datasource for your Access database?

http://www.mathworks.com/help/toolbox/database/gs/braiey2-1.html#bq9n52f-1

Also, it is possible that the MS Access database password might be the same as your Windows machine username/password.

[vinh]

Do you have any different way to set up Data Sources by function, not use the Visual Query Builder.

Thanks.

Answer 2

[vinh]

I have connected to my .mdb, but I could not set up password for it. So I had to set up the password manually in the .mdb file.

Annyone can help me to set up the password through .m file.

Thanks in advance.