First time here? Check out the FAQ!

Unable to delete objects in an Access 2010 database

0 votes
asked by (140 points) about Microsoft Office Outlook
edited by

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?

1 Answer

0 votes
answered by (329k points)
edited by

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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register