Matlab 64 bit Access 32 bit

Question

Brian 2011-11-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/22671-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

3 个评论
显示 1更早的评论隐藏 1更早的评论

Brian 2011-12-1

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 2013-9-10

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 2011-12-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/22671-matlab-64-bit-access-32-bit#answer_32023

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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ken Atwell 2011-12-20

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

请先登录，再进行评论。