Link to home
Start Free TrialLog in
Avatar of Bill Ross
Bill RossFlag for United States of America

asked on

MS Access 2003 MDB Queries cannot be deleted in Access 2010

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
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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

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?
Avatar of Bill Ross

ASKER

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
That was the issue.  Thanks!