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.
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.
Youcan, 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.
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.
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.
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.
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.
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
7 Comments
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611039
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611039
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611064
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611064
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611349
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611349
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611437
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611437
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611531
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611531
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611541
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611541
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611624
Direct link to this comment
https://la.mathworks.com/matlabcentral/answers/419250-i-want-to-know-whether-the-microsoft-access-databases-are-not-recognized-by-matlab-r-2015b#comment_611624
Sign in to comment.