Doug Murphy
dw-murphy at cox.net
Fri Jan 27 15:00:45 CST 2012
Thanks Jim, That will help. I wouldn't use office 64 but can't dictate what other folks use. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, January 27, 2012 12:02 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Issues with running applications in 64 bit version of Office Doug, Here's a link to an EE question which runs through that (it's a logged in view, no need to sign-up). You need to use compiler constants and conditional statements if you want to run one version under both 32 and 64 bit editions: http://rdsrc.us/4FpMQU Also in my second to last comment are links on the compatibility checker, 64 bit calls, etc. Now with that said, I would avoid 64 bit Office at all costs. Even Microsoft has said that it's better to avoid it unless you need large spreadsheets in Excel. There is an overall lack of support for 64 bit, although that is starting to change. Also, I would do two version rather then trying a single version. Very often you will find that an alternative method is required because you can't port something to 64 bit. For example, any of Stephan Lebans code like the snapshot to PDF is not going to run under 64 bit office. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, January 27, 2012 01:45 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Issues with running applications in 64 bit version of Office I have used a slightly modified version of the relinking code from the Access Developers Handbook for many years. I liked using it as it didn't depend on the Office Dialogs so could be used in runtime versions on computers without Office installed. I dropped the code modules into a customer's application as usual when we split their database and all was well. Until they tried running the application on a computer with Office 10 64 bit. Code breaks on the 32 bit api calls. Not good. Has anyone run into this and figured out how to work with both 32 bit and 64 bit versions of Access? For the short term I am going to use the Office dialogs, but would prefer to use the Windows api. Doug -- 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