Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Q and A _ 64 Bit Access

Posted by: ngins Nov 17 2019, 08:45 AM

Sorry if this is been discussed before. I was just wondering for those who have developed apps in 64-bit Access, if you've seen any significant differences between that and 32-bit Access? Better performance? Fewer bugs? Anything that makes switching to 64-bit Access worthwhile?

Thanks !

Posted by: DanielPineault Nov 17 2019, 09:17 AM

In a general sense no, nothing of value. On top of that, you get into having to upgrade your API calls, certain ActiveX controls are not available, ... In some cases, I have heard it has helped with the resource exceeded error, but if that has never been an issue for you, it does little to help you. Typically, one switches to x64 for the benefits you get in Excel, but then again if you're juggling workbooks of the size, you're already using the wrong tool! There are also considerations if you are only installing Access in x64, but the rest of Office is x32 (automation is no longer possible!).

You may like to review https://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/ for a little info on the x32/x64 subject.

Posted by: ngins Nov 17 2019, 09:25 AM

Thanks for the excellent reply! In one database, we have been having problems with the resource exceeded issue. But so far I've been able to address it by just revising my queries or code. I have been having a problem recently with a certain form acting funky on occasion, which may be a corruption issue. So was wondering if there were major differences with using 64-bit access, especially when it came to Access bugs. But it sounds like there aren't.

Thanks again!