none
Run 64 bit from a 32 bit version? RRS feed

  • Question

  • I have developed a database accde in 32 bit, My friend has a 64 bit computer. How do I change it so he can open it?

    Thanks for any help.............Bob


    xxx

    Thursday, October 3, 2019 9:56 PM

All replies

  • You would have to compile your accdb to accde on a 64-bit version of Access.

    -Tom. Microsoft Access MVP

    Thursday, October 3, 2019 10:44 PM
  • The following article may be informative for you, see: http://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, October 3, 2019 11:43 PM
  • Its simple...take your .accdb to the computer that has 64bit Office...open it....it should complain...Just go to Visual Basic Editor and hit Debug -->Compile <nameof your app>...it should pop code that needs fixing...just repeat till its stops complaining.
    Friday, October 4, 2019 5:55 AM
  • "Its simple..."

    For very simple database perhaps, but for any more advanced databases it is more involved.

    You need to convert your API declarations to be PtrSafe compliant

    Then there is the fact that if you use ActiveX controls, they are not all available on 64-bit versions thus potentially breaking the application.

    If you plan on your db working in both environments you need to get into conditional compiler directives.

    If you need to deploy your database as an accde, you need to compile it on each bitness, so as the developer you need to have both a 32-bit and 64-bit installation to be able to generate these.


    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Friday, October 4, 2019 6:50 AM
  • "Simple" is in the concept of process...maybe i should have it quoted

    Either way you have to know what to do...and in the case of converting a 32bit Access Application is the "extra goodies" that cause the problem...WinApi calls which shall get translated to PtrSafe  unsupported ActiveX,dlls....but in every case unless you are super familiar with 64bit VBA and you have rock solid knowledge of your 32bit application you need to find the problems..

    So you start with the "Debug"...oops 1st error an API call that needs PtrSafe...is that all...no way...depending on the arguments and the return type you have to adjust your code

    #IF VBA7 Then

    Dim SomeVariable as LongPtr

    #

    Else

    Dim SomeVariable as Long 'The Same as above

    #End If

    Fixed that...debug to get to the next....Fixed everything ?

    Test the application...does it work....

    IF YES then lucky you...you have your application in both 32 and 64bit ecosystem

    IF NO then you have to do some digging...maybe the variable is not what the API call expected...does the API call has proper support for 64bit (i have some cases that i am pretty sure that the implementation is broken....but i have only started working with 64bit VBA so some good searching is needed)

    Friday, October 4, 2019 8:52 AM
  • Seems quite complicated to change from 32 to 64 bit. but will give it a try at the moment it wont open, so do I go to Compile and go through the errors? I actually tolf him to get windows 32 bit to solve the problem , that would work wouldn't it?

    Regards Bob


    xxx

    Friday, October 4, 2019 8:57 PM
  • Not Windows 32-bit, but rather Office 32-bit is what would resolve this issue.

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Saturday, October 5, 2019 6:49 PM
  • Seems quite complicated to change from 32 to 64 bit. 

    It is not. The advice already given is what it takes - plus a little handwork. And, as a developer, you will have to familiarise with the process, as the 64-bit install of Office will be more and more common.

    Gustav Brock

    Sunday, October 6, 2019 8:01 AM