Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1346
  • Last Modified:

Problem opening Office 365 (Access) with MDB file extension

I can't get Office 365 to recognize my databases which have an MDB extension.
If I open Access and then browse to the MDB file - no problem.
0
DAveB_LDS
Asked:
DAveB_LDS
  • 13
  • 13
  • +1
1 Solution
 
Cris HannaCommented:
Are you using Click to Run Access or do you have full Office Pro installed?
0
 
flubbsterCommented:
Try the simplest solution first:

Right-click on the problem .mdb file.

Select "Open With", and then click on "Choose Default Program."

You will see recommended Programs, look for Access and select it if found.

If Access isn't listed in the Recommended Programs section, click the Browse button, browse to and select msaccess.exe, and then click Open.
0
 
DAveB_LDSAuthor Commented:
Full Office Pro
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
DAveB_LDSAuthor Commented:
Actually Office 365
0
 
flubbsterCommented:
It sounds exactly like a file association issue. Doing what I suggested should correct it automatically.
0
 
DAveB_LDSAuthor Commented:
Before I posted this problem I tried all of those solutions. Even if I browse to MSAccess it doesn't change it.
I also go to Control Panel and attempt to change the file association for MSACCESS to MDB it doesn't accept the change.
0
 
flubbsterCommented:
What exactly happens when you try to open it? Are there any error messages?
0
 
flubbsterCommented:
Another thing you can try is removing the registry entry for the .mdb extension and having the system re-create it. Before deleting it though, look at the keys under it and see what the association is.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.mdb

In the OpenWith folder in the key, it should list MSAccess.exe
0
 
DAveB_LDSAuthor Commented:
I can open the MDB if I open MSAccess first. No problem. If I click open with I can browse to MSACCess, highlight it and click okay. It does not change the association which is set at "Office XML Handler". Therefore the MDB does not open
0
 
flubbsterCommented:
Go into the registry and change it in there as I showed or simply delete the one there then use the right-click-open-with method and see if that sticks.
0
 
DAveB_LDSAuthor Commented:
Thank you for your help. I have to go to  a client now. Will continue later.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Did the association ever work or did it stop working at some point?

You could try repairing Office365 from Programs and Features, there should be Quick Repair (which is quicker), or Online Repair.
0
 
DAveB_LDSAuthor Commented:
It never worked
The MDB extension points to Office XML Handler
I have tried to change the extension association in Control Panel\Default Program Extensions which is basically the registry. It does not change
0
 
flubbsterCommented:
Could you please try this:

Open a command prompt by clicking on run and typing "cmd"  <enter>

At the prompt, type in the following:

assoc |more    (the vertical line is called a pipe and is the one above the backslash)

It will display all the file associations one page at a time. Hit the space bar or enter to go to the next screen and continue until you reach the .mdb one. What does it show there?
0
 
flubbsterCommented:
Actually, it will be easier to just use the following:

assoc .mdb

this will show just the association for the mdb file type
0
 
DAveB_LDSAuthor Commented:
Association not found for .mdb
0
 
DAveB_LDSAuthor Commented:
I researched assoc and entered the following command
.mdb=Access.mdbfile

Access is denied
Error occurred while processing .mdb
0
 
flubbsterCommented:
Very strange. Command prompt again. I don't have Office 365 which is Office 2013, but I think this is correct. Type the following:

CD C:\Program Files (x86)\Microsoft Office\Office15  

(This can be verified first by simply navigating to the correct location first to see if it is office 15, if not, change the number accordingly.)

Once in the correct folder, type this in:

msaccess /r

then

msaccess /regserver

test
0
 
DAveB_LDSAuthor Commented:
The /r option came back with MSAccess doesn't recognize the command and then open up

The /regserver command opened up Access
0
 
flubbsterCommented:
Open regedit from the run box

navigate here:

HKLM\software\classes\.mdb

click on the entry

What is shown in the right-side window?

It should be:

Access.Application.15   (depending on version)
application/msaccess


If you do the same for .docx or .doc, you should see this:

Winword.Application.15
application/winword
0
 
DAveB_LDSAuthor Commented:
Looking in Control Panel /Default Programs/Set Associations
The current default is "Application Unknown"
The same thing that I see when I look at "Set association for a program"
0
 
flubbsterCommented:
You should be able to browse to msaccess to set the default application even if it is not listed
0
 
DAveB_LDSAuthor Commented:
I can browse to it, but when I click "open" it does not change.
I have a feeling that it is some kind of permissions issue.
0
 
flubbsterCommented:
I agree. Especially with the access denied message. Did you do the regedit thing? If so, what did you find?

At this point you may just want to do a full re-install, but not by just using add/remove programs. Here is what to do:

Firszt, go into add/remove programs and verify that office 365 is the ONLY office program showing. If it is, great. If it is NOT, then uninstall the other program (most likely a trial one).

Once you know the only thing installed is Office 365, do the following.

Download and run the Office 365 removal tool. This works extremely well as it resets permissions and removes every trace of office.

http://go.microsoft.com/?linkid=9815935

It takes several minutes to run to completion and will open a "dos box" as it is running. Completely normal so just be patient.

Now, Office 365 allows up to 5 installs I believe. After it is completely removed and you have re-booted, log in to your Office live account. You will see your computer listed as one of the systems it is installed on (or the only system). You can de-activate the license for your PC if you want because it is now gone. Or you can just click on the install button again. I would remove the activation so you still have 4 left.

Install it and let's see what happens.
0
 
DAveB_LDSAuthor Commented:
Thank you very much for your help.
I really thought it was a Windows issue not Office.
0
 
flubbsterCommented:
You are very welcome. I'm curious... did you do the removal and install or change the registry?
0
 
DAveB_LDSAuthor Commented:
Used the removal tool. Previously I worked in the registry with no success.
I think it was definitely permissions, otherwise I would have been able to change control panel
0
 
flubbsterCommented:
Excellent. Glad it is working.

Take care
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 13
  • 13
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now