Results 1 to 10 of 10
  1. #1
    Prayder is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2013
    Posts
    9

    Access Conversion


    I have been tasked with converting our 32 bit access databases over to 64 bit access databases. I literally know nothing about access at all. I was just chosen because I'm the automation guy here at our plant. Could someone direct me in the right direction please? I have researched online and received many conflicting resolutions so Im not really sure what direction to take.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,226
    What is the conflicting information you have?

    Review https://www.devhut.net/2017/04/13/ac...compatibility/


    Last edited by June7; 08-26-2019 at 07:45 PM.
    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.

  3. #3
    Prayder is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2013
    Posts
    9
    Acess Errors.zipI installed Access 64 bit and tried to open a switchboard form in my 32 bit db and recieved this error that I am linking.

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    If your database is an ACCDB file with no APIs and no ActiveX controls it may not need any conversion.
    However....
    1. ACCDE files will only run in the same 'bitness' they were created. You will need a 64-bit ACCDE if xo.
    2. All API declarations will need to be modified for 64-bit using PtrSafe as well as LongPtr for pointers.
    If some users will still be running A2007 or earlier you will need conditional compilation
    Code:
    If VBA7 Then
    Declare PtrSafe ….
    #Else
    Declare
    #End if
    3. Some ActiveX controls do not work in 64-bit e.g. Flexgrid and Treeview. If you use any that don't run in 64-bit, you will need alterntive code.

    Phillip Stiefel has also done a very good guide to conversions https://codekabinett.com/rdumps.php?...ion-vba-64-bit
    Here is an MS guide https://docs.microsoft.com/en-us/off...ions-of-office
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    Prayder is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2013
    Posts
    9
    BoilerTestFE.zipBoilerTestBE.zip

    Here are the front end and back end of the databases.

  6. #6
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    Your error message indicates you have one or more APIs that will need converting.

    I've not looked at you databases but the BE should just contain tables and won't need conversion.
    You need to go through each module in the FE checking each API and converting as necesary
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  7. #7
    Prayder is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2013
    Posts
    9
    Quote Originally Posted by isladogs View Post
    Your error message indicates you have one or more APIs that will need converting.

    I've not looked at you databases but the BE should just contain tables and won't need conversion.
    You need to go through each module in the FE checking each API and converting as necesary
    Ok.. thank you. I will need to find someone that knows how to do all that. As I stated l literally know nothing about Access, vba code, or any of this... Thank you though. Very very helpful!!!

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,226
    All those conditions are discussed in the link I provided. Did you review?
    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.

  9. #9
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,126
    I've had a quick look at the FE.
    There are a lot of APIs that will need converting - too many for me to offer to go through it for you.
    However you may be able to find converted versions online in most cases.

    Some of the code is very old and certain items could be done by other means without APIs
    e.g. use Environ to get user name, Windows File Dialog to browse files/folders.

    Good luck
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  10. #10
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,732
    I had a quick look at the BE. Only tables.... but

    Table "tblVisible_Emission_data" has lots (LOTS) of spaces in field names and special characters - "(", ")", "&".
    Table "tblHourly_Log_Reading" has a space and special characters - " ' "
    Other tables have reserved words: "Hour", "Time", "Description", "State", "Command".
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Conversion to Access
    By bugs63 in forum Access
    Replies: 1
    Last Post: 07-10-2019, 06:53 PM
  2. Access 2.0 and 97 nightmare conversion
    By Gina Maylone in forum Access
    Replies: 4
    Last Post: 07-11-2016, 09:45 AM
  3. Access 2000 to Access 2007/2010 conversion
    By ssissons in forum Security
    Replies: 2
    Last Post: 10-06-2014, 12:31 PM
  4. Replies: 2
    Last Post: 02-11-2014, 07:40 PM
  5. Replies: 6
    Last Post: 04-30-2013, 02:42 PM

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 - Senior Forums