[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