Solved

Cannot double-click on an Access Database to open

Posted on 2004-11-01
503 Views
Last Modified: 2010-05-18
On a Windows XP machine all patched, I had previously installed Access 97 with Office 2000 Pro.  Could not double click to open a database, but can open access and open the the database from there.  Error message I receive is "The command line you used to start Microsoft Access contains an option that Microsoft Access does not recognize"  Exit and restart Microsoft Access using valid command-line options.  If you click on that a couple of times this error comes up, "Microsoft Access can't find the database file c:\documents.mdb make sure you entered the correct path and filename"  I uninstall Access 97 and 2000 and reinstall 2000 only same problem, upgraded to Office XP, same problem.  Help!!!!
0
Question by:tnstech
    5 Comments
     
    LVL 4

    Accepted Solution

    by:
    Humm...

    First I would right click on the access mdb file and click properties. Make sure the Open With is set to Microsoft Access.

    If it is set correctly then I do not know...

    maybe try clicking start-> control panel-> folder options

    In the folder options select the 'file types' tab... scroll down to MDB and click advanced.

    The only advice I can give here is what my system says (I am running Office XP on Windows XP)
    I have 2 action entries.. one says New and one says Open

    In the 'Application used to perform the action' box I have
    "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /NOSTARTUP /n "%1"

    (I really do not know what the options /nostartup /n "%1" mean... I would google Access command line options)

    If you are running Access 97 on a machine running Office XP (without Access) maybe make sure the link is to your version of Access... IE C:\Program Files\Microsoft Office\Office97\MSACCESS.EXE"

    Again, I am just taking stabs at the problem.

    My settings also have DDE enabled.

    If you installed Access 97 and Access XP on the same machine you may have even more problems.

    Hope this helps you in the right direction.




    0
     

    Author Comment

    by:tnstech
    Thank you mydbguy.  Corrected the file association, but I think it may be a little more than that.  

    I noticed under the Windows profile in application data that there was not a section for Access under Microsoft.  So  I copied a folder in from another machine.  I can now right mouse click on the file and select Open with...which will work.   But still cannot double click on the file to open, same error as before.   Also, /nostartup stops that help pane from coming up.   could not find anything on the /n or %1
    0
     
    LVL 4

    Expert Comment

    by:mydatabaseguy
    Does this problem only occur on a single MDB or any MDB on the machine?

    I found one thing regarding your error on microsoft but it has to do with password protected databases...

    here is the link:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;828406

    Have you installed all available updates for Office?

    Good luck.
    0
     
    LVL 58

    Expert Comment

    by:harfang
    "Access can't find the database file c:\documents.mdb"

    This is typical for missing quotes around %1 in the file association commands for Open. Without quotes, you will have:
        <start ms access> <options> C:\Documents and Settings\UserName\Desktop\My New Database.mdb
    Access will look for "C:\Documents" and fail.
    If you add the quotes around %1 (which will be replaced by the long version of the file name), it will work.

    This bug happened frequently before the 2000 versions, in several apps.

    Cheers!
    0
     

    Author Comment

    by:tnstech
    Yes this happens on any database you try to open, all patches are applied.  I will check the quotes around the %1 and let you know.  Thank you!
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    933 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now