Solved

MS Access 2003 MDB Queries cannot be deleted in Access 2010

Posted on 2014-04-17
5
436 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 34

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
HasData 9 36
VBA to alter Table in MS Access .mbd (2000-2003) database 5 28
Auto Filter in Combo Box 7 32
Replace NULL Value in Crosstab query with previous day data 6 29
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

911 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

16 Experts available now in Live!

Get 1:1 Help Now