Issues with access 2010

Posted on 2012-08-16
Medium Priority
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
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 880 total points
ID: 38303960
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

ID: 38318749
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 85
ID: 38319494
Okay - did you try the steps I outlined?

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

840 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