Results 1 to 7 of 7
  1. #1
    rmlcal1@aol.com is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    10

    Moved a database from a windows 7 machine to windows 10 - getting compile errors

    I have to move my Access database from windows 7 to windows 10. When I try to run certain queries or open a form I am getting compile errors. Here is an example of a message from running a query and opening a form
    Click image for larger version. 

Name:	Query.PNG 
Views:	19 
Size:	28.0 KB 
ID:	39226

    Click image for larger version. 

Name:	form.PNG 
Views:	18 
Size:	94.6 KB 
ID:	39227



    The error message from the form doesn't really make sense (The code in this project must be updated for use on a 64 bit systems) since my old machine runs windows 7 64 bit.
    My database is using an old extension MDB so I updated it to accdb - but am getting same error message when run on windows 10.
    Does all the code really need to be updated or is this just a misleading error msg? Seems for a user friendly product moving a database from one version of windows to another would not require code changes.
    Any help/advice would be greatly appreciated

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    When you say "My database is using an old extension MDB so I updated it to accdb"

    How did you go about updating to an accdb ?



  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See https://codekabinett.com/rdumps.php?...ion-vba-64-bit
    and/or https://access-programmers.co.uk/for...d.php?t=283116
    Google/Bing Ms Access PtrSafe


    You may want to research comdlg32 and win 10. There are many sites warning that this is not available for WIN 10. Others claim to have a FIX.
    Good luck.
    Last edited by orange; 07-28-2019 at 01:20 PM. Reason: additional info

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    suggest you look for missing or broken references before going down the road of making db 64 bit compatible.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The error message about updating code for 64-bit systems is only relevant if you are running 64-bit Access.
    The Windows bitness is irrelevant.

    As already stated, there are issues with some old references often used with MDB files when run in Windows 10.
    Amongst the problem references are the old Common Controls library which isn't supplied with Win 10 and doesn't work in the 64-bit version.

    Agree with previous answers.
    First check for missing references and fix where possible.
    If you can't fix a particular reference, disable it and see if the code compiles. Fix any issues arising.
    Then look at altering any API declarations to work in 64-bit Access if that is appropriate in your case.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    rmlcal1@aol.com is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    10
    File - Save As - Save Database As - Access Database (*.accdb)

  7. #7
    rmlcal1@aol.com is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2018
    Posts
    10
    File - Save As - Save Database As - Access Database (*.accdb)

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

Similar Threads

  1. Replies: 5
    Last Post: 04-23-2019, 03:31 PM
  2. Replies: 6
    Last Post: 03-14-2019, 05:47 PM
  3. Replies: 1
    Last Post: 05-11-2018, 10:11 AM
  4. 2010 Runtime Errors with Windows 8.1
    By mwwbutler in forum Access
    Replies: 1
    Last Post: 09-16-2015, 06:57 AM
  5. macro not working in Windows 7 machine
    By vemi007 in forum Programming
    Replies: 2
    Last Post: 04-19-2012, 01:45 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