Unable to delete objects in an Access 2010 database

Question

I have an Access 2010 database that I converted from an Access 2003 database. I opened the access 2003 database .mdb file in Access 2010 and then saved it as an Access 2010 accdb file. I am unable to delete any of the forms, queries, etc. in the access 2010 database. Can anyone tell me why I am not able to do this?

Answer 1

The database cannot be trusted in the Trust Center. If so, the security features of Access 2010 will not allow editing (which means also deleting). If no, then you should try another procedure by following the next steps:

1. Open the old .mdb version of this file in Access 2003
2. Run the Compact & Repair Utility. Compile the VBA code (in the VBA editor click: Debug->Compile).
3. Run the Compact & Repair Utility again.
4. Close Access 2003.
5. Open Access 2010 and create a brand new database in the .accdb format. Then import all of the objects from the .mdb file into this new .accdb file.