Results 1 to 3 of 3
  1. #1
    maxis is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    27

    Warm & Fuzzy Confirmation about VBA Compiled Code in MS ACCESS 365 Pro

    Running 64bit Windows 7 & 10 OS, but 32bit OFFICE 365 Pro (which includes MS ACCESS) on both OS's (Win7 & Win10).



    We assumed that if you compiled MS ACCESS VBA code on a Windows 10 machine (saved as a .accde file), it would NOT run on a Windows 7 machine; that it would not be backward compatible and run on Windows 7. Having said that, the Windows 10 compiled VBA code in MS ACCESS works just fine on the Windows 7 machines.

    Is it the 32bit OFFICE controlling the VBA COMPILER that explains this? And it doesn't really matter about Windows 7 or 10 because they're both the 64bit OS?

    We're just hoping for a warm and fuzzy confirmation that it's more than dumb luck that the Windows 10 compiled MS ACCESS VBA code is running just fine on Windows 7.

    Thanks.
    Maxis

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,020
    you might want to update your details which say you are using 2003.

    broadly speaking the version of windows is irrelevant - what matters is the access version and the access/office bit version. So 64bit access will not run a (access) 32bit compiled .accde and 32bit access will not run 64 bit compiled .accde. Similarly office 2007 will not run later compiled versions of access (2010 and later) - it may run later .accdb's providing it does not use features not available in 2007.

    Both will run the same .accdb's but 64 bit needs some work if using API's (requires the ptrSafe keyword and conversion of some longs, primarily pointers, to longptr)

    Since you are using 32bit access - make sure for new installations your IT dept continues to use the 32bit version. The risk comes when some excel user requires 64bit excel which is the only app that benefits from 64bit - you can't mix office versions on the same machine.

    So - dumb luck!

  3. #3
    maxis is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2013
    Posts
    27
    Thank you! Perfect...

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

Similar Threads

  1. fuzzy match in Access
    By Alaska1 in forum Access
    Replies: 14
    Last Post: 04-22-2019, 04:10 AM
  2. Replies: 2
    Last Post: 09-06-2018, 04:59 AM
  3. Replies: 7
    Last Post: 03-17-2017, 09:13 AM
  4. Replies: 1
    Last Post: 08-25-2016, 05:23 AM
  5. Replies: 8
    Last Post: 06-23-2016, 07:30 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
  •  
Tech Forums: Microsoft Office Forums