• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

Unable to delete objects in an Access 2010 database

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 this access 2010 database.  Can some one tell me why I am not able to do this?
1 Solution
Jeffrey CoachmanMIS LiasonCommented:
Open the old .mdb version of this file in Access 2003

Run the Compact & Repair Utility
Compile the VBA code (in the vba editor click: Debug-->Compile
Run the Compact & Repair Utility again.
Close Access 2003

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.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Can some one tell me why I am not able to do this?

It is a permissions issue with the old MDW file and the way Access 2010 handles it. Nothing you did wrong.

I have only have issue letting Access 2010 try to convert a MDB to accdb. I always create a new blank .accdb and import the objects from the MDB. This is also what boag2000 is recommending.
dsoderstromAuthor Commented:
That worked.  Thank You
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now