Cannot delete tables in Access 2010

OK, this has to be something dumb.  But I can't see it.

I created a brand-new (blank) Access database.  Then imported a CSV file to create a new table.  Now I want to delete the table.    Delete is greyed-out in the context menu.  Select and then the Delete key does nothing??  I tried creating a trivial new table manually...same thing, can't delete it!
 
This is not a case of Access 2003 user security getting in the way.  I just created this database from scratch.

???
LVL 12
Carlo-GiulianiAsked:
Who is Participating?
 
Carlo-GiulianiAuthor Commented:
Found the answer.  The database  has to be opened for exclusive access to be able to delete a table.   The procedure to do that is not obvious...you have to use the file open dialog (you can't just select a file from Explorer or the recent files list).

There is also a client option to open databases for exclusive use by default....but that does not seem to work in every case.

screen shot
0
 
hnasrCommented:
Try deleting Table1 in this database.
If you can then upload your database.
Database1.accdb
0
 
Jared_SCommented:
Did you save the table? If you haven't saved it, then delete isn't available as an option.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Carlo-GiulianiAuthor Commented:
I tried the database example attached by hnasr.  Same problem.  So it seems to be something in my computer or profile configuration.  

Here is a screen image.  Note almost all the toolbar buttons are greyed out.  Including the "Design View" button.  But i can open tables in design view from the context menu...
 
screen image
0
 
hnasrCommented:
Try to run access as Administrator, and open the database and check.

Start Menu, Search Box- Type msaccess.
Right click msaccess and select Run as Administrator.
0
 
etech0Commented:
Is there any security set up in the database?
0
 
Carlo-GiulianiAuthor Commented:
Found the answer myself...nobody was even close.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.