how to open Microsoft access

Question

how to open Microsoft access, when it doesn't want to open, "you must start Microsoft access by double clicking a Microsoft access file, or by running Microsoft access from a command prompt with a database specified" the pop up is. when im already subscription.

Answer 1

Hi @sephia belentina ona

Thank you for reaching out to Microsoft Q&A regarding the issue you're experiencing with Microsoft Access. The error message you're seeing typically indicates the Microsoft Access Runtime version is installed on your device, which limits direct launching of the full application. Since your subscription includes the full version of Microsoft Access, we'll resolve this by removing the Runtime and ensuring the full installation is properly set up.

First, you need to uninstall Microsoft Access Runtime:

Open the Control Panel > Programs and Features > Search for "Microsoft Access Runtime" in the list of installed programs > Select it and click "Uninstall." Follow the prompts to complete the removal > Restart your computer after uninstalling.

Then, Install or Repair the Full Microsoft Access via Your Subscription:

1. Sign in to your Microsoft account at https://portal.office.com/account/?ref=Harmony#installs using the email associated with your subscription
2. Click on "Install apps" or "Install Microsoft 365" (depending on your plan)
3. Download and run the installer. During setup, ensure Microsoft Access is selected if prompted (it's included in plans like Microsoft 365 Personal, Family, Apps for business, or Business Standard)
4. If Access is already installed but not working, repair it instead: In Control Panel > Programs and Features, find "Microsoft 365" or "Microsoft Office > Right-click and select "Change" or "Repair." > Choose "Quick Repair" first, then "Online Repair" if needed.

Reassociate Access File Types (If needed):

After installation, if .accdb or other Access files still open in Runtime mode:

Go to Settings > Apps > Default apps > Search for ".accdb" and set it to open with "Microsoft Access".

I hope this helps clarify the situation.

---

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.

Answer 2

From your description of the behavior, I think you probably have only the Access Runtime installed, not the full Access application. Either that or you have both installed and are trying to start the Runtime version, not the full Access application.

Please confirm which version of Access you have installed.