Results 1 to 7 of 7
  1. #1
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86

    Can't delete access objects from All Access Objects

    I am modifying a colleague's access file but for some reason I cannot delete anything (tables, forms, reports, etc.) from the ALL Access Objects window located on the left hand side when you open the file. Any idea why this might be the case? I've looked around and tried a few things but nothing seemed to work.

    On all my other files I can delete objects just fine, it is only on this particular one from a colleague which I'm having issues with.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Is the file an accde ? This is an executable and design cannot be modified.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86
    Quote Originally Posted by June7 View Post
    Is the file an accde ? This is an executable and design cannot be modified.
    ACCDB actually, I'm able to import new objects into the file but I can't delete objects already in the file.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Never encountered this. If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Sounds like the navigation pane is locked. This results in certain context menu items such as rename and delete being disabled

    If that's the case, open the VBE and in the Immediate window type
    Code:
    DoCmd.LockNavigationPane False
    That should restore it to normal
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    TerraEarth is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Posts
    86
    Quote Originally Posted by isladogs View Post
    Sounds like the navigation pane is locked. This results in certain context menu items such as rename and delete being disabled

    If that's the case, open the VBE and in the Immediate window type
    Code:
    DoCmd.LockNavigationPane False
    That should restore it to normal
    Still no luck unfortunately.

    I inherited this file from another user (long gone) in another department and there's no log or anything of that sort that explains what might have occurred to make this happen.

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Can you show a screenshot of the nav pane and/or upload your database.
    There is a chance that you have corruption. You should try each of these in turn - compacting, decompiling, copying all objects into a new blank database
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access keeps on resizing objects by itself
    By brunces in forum Access
    Replies: 2
    Last Post: 11-18-2016, 12:19 PM
  2. Replies: 2
    Last Post: 04-27-2016, 06:56 AM
  3. How do i rank objects in access
    By Erickson in forum Access
    Replies: 0
    Last Post: 08-22-2013, 10:51 AM
  4. Replies: 7
    Last Post: 11-16-2009, 11:56 AM
  5. All Access Objects shows nothing
    By Viwadd in forum Access
    Replies: 5
    Last Post: 05-29-2009, 02:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums