Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    strange access msg while firing up excel (2000)

    hi --

    recently i have been getting a weird msg from excel upon starting up ... it says "excel cannot open access mdb files directly" (i've attached a screen shot) ... the msg goes on to explain how to import mdb files ... it comes up twice and then lets me into excel ... the problem is that i've been getting this msg even before i try to open ANY files ... i've tried repairing and reinstalling, but to no avail ... it seems to be a data issue, and i've gone into the application data folder to try to catch any auto start files, but deleting everything in that directory has not helped!

    any suggestions on how to get rid of these pesky messages??

    thanks

    steve weiss
    Attached Images Attached Images

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    Have you taken a look in your XLStart folder, or any other folder you may have designated as a startup folder. It looks like XL is trying to open a Access file at startup and unless you have code that is causing this, it must be finding an Access file in a startup location.

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    thanks for your suggestion, but i had already cleaned out that folder ... could there be something in the registry?? or another folder?

    thanks

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: strange access msg while firing up excel (2000)

    Did you also check the Tools, Options, General, Alternate Startup File Location Folder?
    -John ... I float in liquid gardens
    UTC -7DS

  5. #5
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    no luck ... there was an xlstart folder, but nothing was in it

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    Check your windows WindowsApplicationDataMicrosoftExcel... or WindowsProfilesUsernameApplicationDataMicrosoftExcel... for possible paths to an alternate XLStart folder.

    Andrew C

  7. #7
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    checked those locations, as well as did a find on xlstart ... no luck ... what is the file name that i'm looking for?? is there another folder, other than xlstart, that could be the offender?

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: strange access msg while firing up excel (2000)

    How about finding all MDB fiiles on the C: drive, and see if they don't belong where they are? (Groping in the dark here.)
    -John ... I float in liquid gardens
    UTC -7DS

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    Not unless you defined one in th ealternate file location as suggested by JohnBF above. Have you any files at all in any of these folders, such as Persoanl.xls or Book.xlt.

    If tyou do, check those files to see if they contain some code or refferences to the unwanted file. It is possible that some other file has code to execute a macro that performs a query involving the Access file.

    Andrew C

  10. #10
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    no luck ... no personal.xls or book.xls

  11. #11
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    Are you starting Excel from a shortcut? If so, check the command line in the shortcut to see if it has a filename on it that Excel is trying to open.

    Also, in Excel go to the Addins command on the Tools menu. Write down everything that is checked and then uncheck them. Close Excel and start it back up. If the message goes away, recheck the things that were checked one at a time until you find the one causing the problem.
    Legare Coleman

  12. #12
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    Just to clarify, Book.<big>xlt</big> is the defaultt new workbook template, not Book.xls.

  13. #13
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    yes, i know ... i have not been able to find ANY file (or file look alike, like book.xlt or book.xls) that gets rid of the error message ... there's nothing in my add-ins or other application data directory ... could there be a registry setting? any other suggestions?

  14. #14
    Star Lounger
    Join Date
    Aug 2001
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000)

    i am running from the quicktask bar usually, but have double-checked to see whether that is the problem, and i get the same result even when i double-click execel.exe

    i checked the addins menu item and nothing is checked ...

    i know this is something stupid, but it's hidden and not one of the usual culprits

    could this be a registry setting?

    also, i noticed when i uninstalled/reinstalled office, my preferences had remained. is the place that holds preferences, et al, causing this?? if so, how do i start with a totally clean slate?

  15. #15
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: strange access msg while firing up excel (2000

    Hi. A further (remote) thought: you don't, by any chance, have a shortcut lurking in your start-up or alternate start-up folder? This will give the same effect as if you actually had the file itself sitting there. HTH
    Gre

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •