
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.