Solved

MS Access 2003 MDB Queries cannot be deleted in Access 2010

Posted on 2014-04-17
5
434 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
Comment Utility
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
Comment Utility
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 34

Expert Comment

by:PatHartman
Comment Utility
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
Comment Utility
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
Comment Utility
That was the issue.  Thanks!
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

743 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

14 Experts available now in Live!

Get 1:1 Help Now