Issues with access 2010

Posted on 2012-08-16
Last Modified: 2012-08-22
Hello all
I have an access 2010 database, one day I went to delete a table andit was teeter out so I decided to compact it but that didn't help. I went to command option then navigation to go and hide the table but when I click on navigation I get an error message saying that this command is not available.  I can create tables but when it comes to delete I right click and nothing. I also highlighted and tried to delete by pushing the delet button on the keyboard. I get nothing.
Question by:gigifarrow
    LVL 84

    Accepted Solution

    I don't know what "teeter out" means - could you explain?

    However, it sounds as if you cannot Delete objects from the database. This could be caused by many things:

    Does this behavior occur in ALL databases, or just one?

    If it's in all dbs, then you may have an issue with Office or Windows. Be sure that you've installed all relevant updates to both Office and Windows. Reboot the machine and try again.

    Are you running multiple versions of Access on the same machine (like 2007/2010 and 2003/2002/2000)? If so, then be sure to reboot when you need to switch between those platforms - or use some sort of virtualization software to run one or the other.

    If this happens in only one db, then you may have some corruption. Do this:

    1. Compact the db
    2. Compile the VBA code - from the VBA Editor click Debug - Compile. Fix any errors, and continue this process until the menuitem is disabled.
    3. Compact again.

    You may also need to Decompile the db:

    Build a shortcut with this as the Target:

    "full path to msaccess.exe" "full path to your db"

    Run that shortcut, then run the 3 steps above again.

    Finally, try moving everything into a new, blank database.

    Before doing any of these things, however, MAKE A BACKUP.

    Author Comment

    sorry i meant to say when i right  click to delete a table it is grayed out. when i take it to another computer and open it up in 2007 and it does the same thing
    LVL 84
    Okay - did you try the steps I outlined?

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    733 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

    20 Experts available now in Live!

    Get 1:1 Help Now