Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problem opening Office 365 (Access) with MDB file extension

Posted on 2015-02-16
28
Medium Priority
?
1,124 Views
Last Modified: 2015-02-18
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
Comment
Question by:DAveB_LDS
  • 13
  • 13
  • +1
28 Comments
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 40613520
Are you using Click to Run Access or do you have full Office Pro installed?
0
 
LVL 30

Expert Comment

by:flubbster
ID: 40614514
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
 

Author Comment

by:DAveB_LDS
ID: 40614515
Full Office Pro
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:DAveB_LDS
ID: 40614517
Actually Office 365
0
 
LVL 30

Expert Comment

by:flubbster
ID: 40614535
It sounds exactly like a file association issue. Doing what I suggested should correct it automatically.
0
 

Author Comment

by:DAveB_LDS
ID: 40614549
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40614555
What exactly happens when you try to open it? Are there any error messages?
0
 
LVL 30

Expert Comment

by:flubbster
ID: 40614574
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
 

Author Comment

by:DAveB_LDS
ID: 40614576
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40614583
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
 

Author Comment

by:DAveB_LDS
ID: 40614590
Thank you for your help. I have to go to  a client now. Will continue later.
0
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 40615132
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
 

Author Comment

by:DAveB_LDS
ID: 40615368
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40616443
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40616452
Actually, it will be easier to just use the following:

assoc .mdb

this will show just the association for the mdb file type
0
 

Author Comment

by:DAveB_LDS
ID: 40616478
Association not found for .mdb
0
 

Author Comment

by:DAveB_LDS
ID: 40616501
I researched assoc and entered the following command
.mdb=Access.mdbfile

Access is denied
Error occurred while processing .mdb
0
 
LVL 30

Expert Comment

by:flubbster
ID: 40616559
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
 

Author Comment

by:DAveB_LDS
ID: 40616600
The /r option came back with MSAccess doesn't recognize the command and then open up

The /regserver command opened up Access
0
 
LVL 30

Accepted Solution

by:
flubbster earned 2000 total points
ID: 40616616
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
 

Author Comment

by:DAveB_LDS
ID: 40616620
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40616625
You should be able to browse to msaccess to set the default application even if it is not listed
0
 

Author Comment

by:DAveB_LDS
ID: 40616770
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40616799
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
 

Author Closing Comment

by:DAveB_LDS
ID: 40616905
Thank you very much for your help.
I really thought it was a Windows issue not Office.
0
 
LVL 30

Expert Comment

by:flubbster
ID: 40617153
You are very welcome. I'm curious... did you do the removal and install or change the registry?
0
 

Author Comment

by:DAveB_LDS
ID: 40617174
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
 
LVL 30

Expert Comment

by:flubbster
ID: 40617184
Excellent. Glad it is working.

Take care
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Suggested Courses

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question