473,323 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

What Causes This??

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
Nov 13 '05 #1
2 1304
"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)
Nov 13 '05 #2
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
"Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
news:uV*************@TK2MSFTNGP11.phx.gbl...
"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)

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: David Walker | last post by:
Hi I've been doing a site in css recently, and have come across the problem of IE not allowing text to be selected. The problem is, sometimes it does allow it, and sometimes it doesn't, and i'm...
3
by: Jukka K. Korpela | last post by:
I have noticed that the meaning of visibility: collapse has been discussed on different forums, but with no consensus on what it really means. Besides, implementations differ. The specification...
1
by: Alexander Jhin | last post by:
I have this very basic Custom Control: public class TestPanel : Panel { public TestPanel() : base() { this.SetStyle( ControlStyles.AllPaintingInWmPaint | ControlStyles.Opaque |...
1
by: craigkenisston | last post by:
Microsoft's datarepeater sample causes warning in the IDE. Hi, The code here : ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpgenref/html/cpconrepeaterwebservercontrol.htm Causes the...
2
by: Tav | last post by:
this seems to be a very generic error message, and the fact that i have no way of locating what causes the error is frustrating. anyway, i'll be general with my problem. i have a div on my page...
7
by: amit | last post by:
Hello everybody, I need your advice on this. In my javascript I'm using two anchor <A> which both are to download a pdf file. That works fine but my question is why the "this" parameter in...
12
by: semut | last post by:
Given that the string is of null terminated type. What could be the possible causes (by experience) the string to have no null terminated and cause buffer overflow later. I know it is quite broad,...
7
by: semut | last post by:
Given that the string is of null-terminated type. What could be the possible causes (by experience) the string to have no null character (\0) and cause buffer overflow later. I know it is quite...
1
by: Sard | last post by:
http://rgruet.free.fr/PQR25/PQR2.5.html says "Optimize generated bytecode (also PYTHONOPTIMIZE=x). Asserts are suppressed." Is removing asserts all it does, where can I find more details? I'm...
45
by: loudking | last post by:
Hello, all I don't quite understand what does ((time_t)-1) mean when I execute "man 2 time" RETURN VALUE On success, the value of time in seconds since the Epoch is retu rned. On error,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.