"Jack" <jh********@earthlink.net> wrote in message
news:YD*****************@newsread2.news.atl.earthl ink.net
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
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 Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)