Access step by step guide for creating a 64 bit copy of my 32 bit project

Murray Brown
Murray Brown used Ask the Experts™
on
Hi
I am setting up a second computer with Office 64 bit on so that I can offer a 64 bit version of my Access 32 bit project.
I am looking for instructions on how to do this.
Can anyone recommend a simple step by step guide

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
I've never seen any guide.

You need to convert all the API declarations, all the variable declarations throughout your code to match as required.  The following is extremely useful for converting the declarations: https://www.microsoft.com/en-ca/download/details.aspx?id=9970!
You need to deal with any ActiveX controls that you may have implemented (some may not have any 64-bit equivalents, so you'll need to decide what to do there if that is the case)


Remember, any accde files need to be created on there respective bitnesses.
You may also like to briefly review: https://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
No real step by step that I'm aware of.   What you'll need to do is look at a couple of things:

1. Any API calls.
2. Use of ODBC drivers
3. Any use of Active-X controls or COM components.

On the first, if you use any API calls, you'll want to carefully read:

Compatibility Between the 32-bit and 64-bit Versions of Office 2010
http://msdn.microsoft.com/en-us/library/ee691831(office.14).aspx

and focus on the section "Introducing the VBA 7 Code Base"

This download:
http://www.microsoft.com/download/en/confirmation.aspx?displaylang=en&id=9970

Contains many of the common Windows API calls that most of us use.

This one:
https://docs.microsoft.com/en-us/previous-versions//aa383663(v=vs.85)?redirectedfrom=MSDN

 has all the new 64 bit calls that were added, but you probably won't have used any of these.

 If you don't use any of the above, it's entirely possible that your app will run without modification.   The only real way to know is to test, test, test.

HTH
Jim.
John TsioumprisSoftware & Systems Engineer

Commented:
Just copy your 32bit application to 64bit..let it complain ...
VBE -- > Compile..find the points where it marks as non 64bit friendly,,,,work your way to bring it to 64bit
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Just to be clear, a clean compile alone doesn't cut it.  You need to test all functionality.

Jim.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial