Solved

MS Access 2003 MDB Queries cannot be deleted in Access 2010

Posted on 2014-04-17
5
440 Views
Last Modified: 2014-05-23
Hi,

I have a 2003 mdb file that has worked OK for years.  Client upgraded to 2010.  They can create queries, rename queries but the delete option is grayed out and the delete button does not work.  The mdb is in a trusted location.

I can open the same mdb in version 2007 or 2003 and queries can be deleted.

Any suggestions?

Bill
0
Comment
Question by:Bill Ross
5 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 40006225
Is your database workgroup secured (with a .MDW file)?

If so, try this:

1.  Enter the username and password to an account with admin privileges
2.  Under User and Group accounts, clear the password for the Admin user (the actual Admin account, not just any user with admin privileges)

Close and reopen the database.  

Is the delete option available now?

(You can reset the password for the Admin user at this point and you should still be be to delete queries and other objects)
0
 
LVL 18

Expert Comment

by:Dennis Aries
ID: 40006233
It has happened before that certain actions cannot longer be done in newer versions of access.
Although this specific problem hasn't been observed by myself, you can always use SQL to delete a query.

DROP TABLE <queryname>

Open in new window

0
 
LVL 35

Expert Comment

by:PatHartman
ID: 40007447
Are you sure the .mdb is from A2003?  Could it have been created in an earlier version that A2010 will not update?  Can other objects be changed/deleted?
0
 
LVL 14

Author Comment

by:Bill Ross
ID: 40009042
Hi All,

The database is 2003 format but it might have been converted.  I'm checking with the client this weekend.  I'll keep you posted.

Thanks,

Bill
0
 
LVL 14

Author Closing Comment

by:Bill Ross
ID: 40085973
That was the issue.  Thanks!
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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…

822 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