Forum Discussion

ManojK365's avatar
ManojK365
Copper Contributor
Feb 16, 2017

How to convert Access 32 Bit Database to Access 64 Bit Database

How to convert 32 Database created with Access 2007 32 bit to Access 2016 64 bit? Manoj Kumar

30 Replies

  • Irahawi's avatar
    Irahawi
    Copper Contributor

    ManojK365 

     

    Hello, i like to get some online assistance converting an existing database.  Do you offer this service ?

     

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor

      Irahawi 

       

      I should have included a few more details in my previous response.

       

      Many developers and consultants would be competent to help you convert an existing accdb to work under both 32 bit and 64 bit Access. The skills and knowledge are commonly available. You can do it yourself, assuming you have some VBA experience. However, if you are an end user and have no idea how to work in VBA, hiring someone to do it does make sense. I have seen offers to do that in some forums. Most of the time I think the volunteer offering has the necessary skills and knowledge, but the fact of the matter is that everyone here is an independent developer who volunteers time to the forum community. They may be well-seasoned, or they may have no more experience than you do yourself.

       

      That means it's up to you to choose wisely whether to accept such an offer or not. 

       

      If you decide to have someone help you, the very first step would be to establish the scope of the project. Make sure you understand what will and won't be forthcoming.

       

      You'll need to have a non-disclosure agreement. If you turn your accdb over to someone for the purpose of converting the VBA to support 64 bit Access, you have to be sure that any data exposed will be completely confidential. 

       

      Good luck with the project.

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor

      Irahawi 

      That's not really how forums work.  People ask and answer questions and can refer specific problems to resources, though. We've done that here. I posted links to videos illustrating the process, for example

       

      If you need to hire someone to convert multiple existing mdbs or accdbs from 32 bit to 64 bit, you could search for consultants who do that.

       

      Or, with a little bit of work, you should be able to do the conversion. 

    • Sven Johannsen's avatar
      Sven Johannsen
      Brass Contributor

      Irahawi No, sorry. I never have done this as a service. Was just a consumer with some experience, posting. It was at a time period when Office was predominantly 32 bit, and didn’t come with Access. People would go and get 64bit Access, which caused all sorts of issues when you mixed them. You could go get 64bit Office which had some compatibility issues with add ons and extensions, or stick with 32 bit Access. Should just be able to open a 32 bit Access file in 64 bit and fix a few errors. If it’s a pretty old DB, might have to hunt up a version of Access just a couple of versions newer, convert, and do it again, until it works in a current version. Surprised this thread is still alive.

  • Lewis-H's avatar
    Lewis-H
    Iron Contributor
    You cannot convert an mde!

    You need the original mdb that was used as source to create the mde. You can compile the mdb to either a 32-bit mde with a 32-bit Access or to 64-bit mde with a 64-bit Access.
  • Spengler1776's avatar
    Spengler1776
    Copper Contributor

    ManojK365 I'm not sure if you had a compile issue with VBA or not, but I used https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/visual-basic-language-reference to solve my syntax issue.  It turns out that the difference between my 32 bit and 64 bit database was PtrSafe after my Declare statements.

     

    #If VBA7 Then
    Declare PtrSafe Sub...
    #Else
    Declare Sub...
    #EndIf

     

    I hope this helps out.

Resources