I want to know whether the Microsoft Access databases are not recognized by MATLAB R 2015b?

I want to know whether the Microsoft Access databases are not recognized by MATLAB R 2015b? I ran the Access database with MATLAB R 2009 and it worked well. What I have to do if I want to run the Access database with R 2015b.

[dpb]

I "know nuthink!" about MS Access per se, but you might check out if ODBC Microsoft Access gives you an joy...

[Rik]

Just a note to confirm: you are indeed talking about Access databases and not about the Matlab .mat file?

[Siva]

Actually i wrote a programme (M-file) in that i used some database commands like connecting to database, some sql statement like select, fetch to obtain the required data from the Microsoft Access (2007 version) database. The same file i ran in MATLAB R 2009. successfully. But when I wanted to run the programme in MATLAB R 2015b. It is giving 'invalid connection' error message.

[dpb]

You can, I presume, still use the previous code with prior release, correct?

In the looking I did, it doesn't appear that MS Access is specifically mentioned in the database TB doc any longer.

I suggest a call to Sales at the "Contact Us" link to confirm what is in the product by release if can't find that information readily at the Documentation link for your release.

[Siva]

can i install MATLAB R 2015b in one drive (say C drive) and MATLAB R 2009a in another drive ( say D drive). will both MATLAB versions work well if do like that.

[dpb]

You can install many releases; all you need to do is to create a unique installation location -- I just simply name the root directory MLR2017, say (to date I've not installed anything but 'b' releases so haven't bothered at that sublevel). I have three releases installed and working presently with no issues.

[Rik]

To clear up any further ambiguity: those unique installation folders don't have to be on the same drive. You might have issues installing to removable drives, but I never tested that.

Answer 1

[Titus Edelhofer]

Hi,

one problem might be the version you have: could it be that your R2009a was 32 Bit whereas your R2015b is 64Bit? In this case it could be problematic to access the 32 Bit MS Access DB.

Titus