New MS Access User On Machine

Stewart Berman 21 Reputation points
2025-07-29T02:05:13.28+00:00

Windows 10
Office 2020

We have a standalone machine with Office 2020 installed. There was one user on the machine when Office was installed. He is an MS Access developer. We needed to have another user added to the machine to help with an Access project. The second user logged into the machine and attempted to use an Access database. It appears that user is missing Access capability. Does this user need to run an Access installation of some type to be able to work on the Access database?

Microsoft 365 and Office | Access | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Tammy-Ng 2,535 Reputation points Microsoft External Staff Moderator
    2025-07-29T08:37:49.9533333+00:00

    Dear Stewart Berman
    Welcome to the Microsoft Q&A Forum and thank you for reaching out to share your issue.

    Based on the information you provided, it seems you're looking for a solution to enable Microsoft Access functionality for a second user on a standalone machine where Office 2020 is already installed.

    According to my research, you can try the following troubleshooting steps:
    -Check the Office installation type:
    If Office was installed using a Per-user configuration, you may need to reinstall Office (or Access) using a Per-machine setup so that all users on the device can access the full suite.

    To do this:
    Go to Control Panel → Programs → Programs and Features
    Select Microsoft Office
    Click Change
    Choose either Quick Repair or Online Repair

    -Reinstall or modify Access for the second user:
    If Access is not available for the second user, you can rerun the Office 2020 installer and select Modify to ensure Access is included for all users.
    Make sure your Office license includes Access, some editions like Home & Student do not.

    -Check folder and file permissions:
    Ensure the second user has read/write access to the folder containing the Access database. If the database uses libraries or macros, confirm that all necessary components are installed and enabled for that user.
    We hope this helps resolve your issue. Please let us know if you need further assistance.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.   

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.