Darryl Collins
darryl at whittleconsulting.com.au
Mon Mar 31 17:40:33 CDT 2014
Hi David, We tried and tested the 64 Bit version of Access. No advantage on performance of size at all, but brought a number of headaches with code and connections. Little value to it. Current best set up seems to be Windows 64 Bit OS with Office 32 installed. That approach is largely seemless. There are too many drivers and bits missing to be confident that Office 64 bit behave when you need it to. As Jim Said, Even MS themselves don't recommend you use the 64 bit version of Office This might be useful: <<https://office.microsoft.com/en-au/support/choose-the-32-bit-or-64-bit-version-of-office-HA102840825.aspx>> and covers the pros and coms clearly. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Tuesday, 1 April 2014 7:20 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2010 32 bit vs 64 bit Thanks all. Just the ammunition I needed. Regards David Emerson Dalyn Software Ltd Wellington, New Zealand -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, 1 April 2014 4:58 a.m. To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2010 32 bit vs 64 bit <<Is there any disadvantage in running a 32 bit developed database on a 64 bit install of Access?>> As long as you don't use any API calls, 3rd party DLL's etc, it will work. However, keep in mind that any calls made by Office will be 64 bit, so for example you need all 64 bit ODBC drivers if your talking to an external data source. In some cases, that can be a problem as 64 bit drivers may not be available. If you do any of the above, then the app will need to be re-worked. I really would discourage them from going with 64 bit Office. There are very few advantages (in fact only two - very large spreadsheets in Excel and one other which escapes me at the moment), and many down sides. In fact Microsoft itself still recommends 32 bit Office for 64 bit OS's. You also cannot mix and match 32 and 64 bit. i.e. 64 bit Excel and 32 bit Access. It's one or the other. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Monday, March 31, 2014 03:22 AM To: AccessD Subject: [AccessD] Access 2010 32 bit vs 64 bit Listers, I have a client who are requesting to use 64 bit Access for their project. Is there any disadvantage in running a 32 bit developed database on a 64 bit install of Access? Any reason why they shouldn't use 64 bit? Regards David Emerson Dalyn Software Ltd Wellington, New Zealand -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com