What Causes This??

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

I have Access97, Access2000 and AccessXP installed. Everything has worked
fine for a long while! Something weird started a couple of days ago. When I
double click on an Access file (any version) in Windows Explorer, Excel
opens with a dialog box titled Select a Table and there is a list of the
tables in the dialog box.

Does anyone know what may be causing this? Was some setting accidently
changed?

Thanks!

Jack
 
Jack said:
I have Access97, Access2000 and AccessXP installed. Everything has
worked fine for a long while! Something weird started a couple of
days ago. When I double click on an Access file (any version) in
Windows Explorer, Excel opens with a dialog box titled Select a Table
and there is a list of the tables in the dialog box.

Does anyone know what may be causing this? Was some setting accidently
changed?

Thanks!

Jack
Click to expand...

It sounds to me like something has set Excel to be the application that
opens the .mdb file type. In a Windows Explorer window, click Tools ->
Folder Options... -> File Types, and check out the MDB extension (and
other Access-related extensions). See what they're registered to open
with. If it's Excel, change it back to Access.

Hmm, before you do that, try this: start Access 2002 from the Start
menu, then use that instance of Access to open any .mdb file. See if
that clears up the problem.
 
Dirk,

Thanks for responding!

The second option did not work but you correctly diagnosed the problem -
Excel was set to open .mdb files. I have no idea how it got that way but
changed Excel to Access and all is right again. BTW, there was a choice
between Access97 and AccessXP and I chose AccessXP.

Jack
 
Back
Top