Forum Discussion

WJManels's avatar
WJManels
Copper Contributor
May 08, 2021
Solved

The difference in the Access from Microsoft 365 Home versus Business versions

Program I wrote in Access through Microsoft 365 Home do not run in Access through Microsoft 365 Business. Can anyone tell me why.

  • You can easily check whether its the full version or runtime.
    Open an ACCDB file in Access. Can you see the navigation pane and the full menus? If so its the full version.
    If you can only see the File menu and no navigation pane ... its Runtime

    If some basic code doesn't run then you have an issue with missing Access references.
    If you have a full version, open the VB Editor, go to Tools ...References and take a screenshot of the references then upload here. Are any marked as MISSING?
    However, there is nothing you can do about missing references if it is a Runtime version

6 Replies

  • What happens when you try to run the app in 365 Business
    Was a full copy of Access supplied with M365 Business?
    • WJManels's avatar
      WJManels
      Copper Contributor
      I lot of the functions don't work, even the Docmd.close
      • isladogs's avatar
        isladogs
        MVP
        You can easily check whether its the full version or runtime.
        Open an ACCDB file in Access. Can you see the navigation pane and the full menus? If so its the full version.
        If you can only see the File menu and no navigation pane ... its Runtime

        If some basic code doesn't run then you have an issue with missing Access references.
        If you have a full version, open the VB Editor, go to Tools ...References and take a screenshot of the references then upload here. Are any marked as MISSING?
        However, there is nothing you can do about missing references if it is a Runtime version
    • WJManels's avatar
      WJManels
      Copper Contributor
      I'm not sure but I don't think so. When I looked up the version it simply said Microsoft 365.