Solved

MS Access 2003 MDB Queries cannot be deleted in Access 2010

Posted on 2014-04-17
5
442 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 36

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

821 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