Results 1 to 10 of 10
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Convert Access database


    I created a database. I'm using Windows 10 64 bit. When I converted my database to .accde file, it cannot be used by some of the people I sent it to. It gives an error due to the 64 bit. I was told that the best way to do it is to use Windows 7 32 bit. My database is completed. Is there a way to get it to work with previous versions?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If your MS Access is 32 bit, it should not be affected by the fact that you are using Windows 10 64 bit. I'm a bit confused when you say "Is there a way to get it to work with previous versions?". Previous versions of what?

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you cannot run a 2013 .accde from say 2010 and you cannot run a 32bit .accde from a 64bit version of access or visa versa. You should be able to run a .accde created in 2010 in 2013.

  4. #4
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    It took me while to find out what was going on. I created the database in 32 bit. It works fine as .accdb file. But, when I changed it to .accde file, it gave me problems. It said that it was created as 32 bit so it needs to be opened in 32 bit. It looks like the computers trying to open it are 64 bit. I'm guessing that there is no way to open it with the 64 bit access?

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Not having problem running a very simple accde built with 32bit Access on 64bit Windows 10.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    It looks like the computers trying to open it are 64 bit. I'm guessing that there is no way to open it with the 64 bit access?
    Correct - a 64bit office computer cannot run a .accde created in 32bit office

    @June - you are saying 64bit windows 10 - do you mean 64bit office? If so, then my previous statement is incorrect and I will need to revisit my understanding

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    32bit Office and Access. 64bit Windows 10.

    Odd, changed my profile to Windows 10 and it is not showing on existing posts.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I have a 64 bit Windows 10. Created 32 bit Access database. There's no way to run it on a 64 bit Office? Is there a way to convert it so that it will work?

  9. #9
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I didn't think this would work. I opened up the 64 bit Office and copied and pasted the tables, queries, and forms from the 32 bit onto the 64 bit. I saved it and made the .accde file. It worked.

  10. #10
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Code:
    There's no way to run it on a 64 bit Office?  Is there a way to convert it so that it will work?
    64bit windows is a given these days. a 32bit .accde will not run on 64bit office (and visa versa) because their libraries are different and as a .accde, you have fixed the libraries. There are two solutions 1) supply a .accdb, in which case access will swap in the correct libraries or b) create your .accde from 64bit access - you will then have two versions of .accde.

    Note there are differences between 64bit and 32bit vba, in particular how you declare api functions making use of ptrsafe and longptr - see this link for a detailed explanation. https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Convert Access Database from 2010 to 2013
    By banpreet in forum Access
    Replies: 1
    Last Post: 06-05-2017, 01:49 PM
  2. Replies: 1
    Last Post: 02-25-2013, 09:54 AM
  3. Replies: 2
    Last Post: 02-24-2013, 10:18 PM
  4. Replies: 14
    Last Post: 04-10-2012, 06:37 AM
  5. Replies: 1
    Last Post: 11-25-2011, 11:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums