Matlab 64 bit Access 32 bit

We use a few access databases for storage of some of our in house data. When we have a 64 bit version of Matlab on the same machine as a 32 bit version of Microsoft Access it seems like all of our attempts to pull from the Access databases fail. I know there is an issue with 64->32 bit compatibility but is there any way around this without having to upgrade our version of Access? It's difficult to upgrade our Office package as we have many Excel add-in's from external vendors that are currently only written in the 32bit form.

Thanks for any help you can offer, Brian

[Kaustubha Govind]

Have you tried installing 32-bit MATLAB instead?

[Brian]

Well, I know 32 bit Matlab works with 32 bit Access but that defeats the purpose of having 64 bit Matlab (access to a lot more RAM for our larger jobs)

[Keith Phillips]

Any updates on this problem did you find a work around? My company will not allow me to use 64 bit Office but I have to use 64bit Matlab.

Answer 1

[Brian]

After speaking with support multiple times it appears that this is currently not possible. The accessing of a 32 bit Office application data via 64 bit Matlab would require Microsoft to create an ODBC driver to do so. Currently there is nothing like this available.

[Ken Atwell]

Yes, unfortunately in-process communication requires that both software packages to be 64-bit. http://www.mathworks.com/products/matlab/preparing-for-64-bit-windows.html#12