After using the compact and repair function manually from the manage tab of
Access 2007, a glitch occurs where i cannot rename, delete or cut any of my
objects (tables, forms, queries, etc). The options are greyed-out when i
right-click on the object in the left object pane. Any way to rectify this
issue so i don't have to backtrack to an earlier back-up of my database?

Can you open up a new database and import everything from the problem
database into the new one?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"zmelroy" wrote:

> After using the compact and repair function manually from the manage tab of
> Access 2007, a glitch occurs where i cannot rename, delete or cut any of my
> objects (tables, forms, queries, etc). The options are greyed-out when i
> right-click on the object in the left object pane. Any way to rectify this
> issue so i don't have to backtrack to an earlier back-up of my database?

I tried, but it did not quite solve it. Exporting only my main table to a new
database, the functionality was there. After exporting all my other objects,
the functionality was magically disabled again. No error messages appeared
though. Copying and pasting all the objects into a new database gives the
same result as well.


"Jerry Whittle" wrote:

> Can you open up a new database and import everything from the problem
> database into the new one?
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.