Bill Ross
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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
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
ASKER
That was the issue. Thanks!
Although this specific problem hasn't been observed by myself, you can always use SQL to delete a query.
Open in new window