Results 1 to 6 of 6
  1. #1
    RookieJack is offline Novice
    Windows 10 Office 365
    Join Date
    May 2020
    Posts
    2

    My objects (2 tables, 2 forms, 2 queries, 1 report) have vanished from my navigation pane


    I had some exposure to Access 20+ years ago, haven't used it since, and two weeks ago, started building my
    first-ever database. I was satisfied with myself - I got two tables working, had created two forms, two queries and
    a report. I envision six tables when my project is done, so last night, I went to start building my third table and
    Poof! all my objects have completely disappeared from the navigation pane! 1) I rebooted. no help.
    2) I checked my recycle bin. Not there. 3) I tried Show Hidden Objects and still nothing is showing in my Navigation
    Pane. The only good news is that I have a saved version of my database from four days ago, so I did not lose
    14 days' work, I only lost three days' work. I hope this is an easy fix - I am a rookie and I am mystified
    (and distraught)!

  2. #2
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,342
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  3. #3
    RookieJack is offline Novice
    Windows 10 Office 365
    Join Date
    May 2020
    Posts
    2
    Bob, Thanks, but that didn't work, either. Seems like my object just got vaporized.

  4. #4
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,342
    can you post a copy of the db
    If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
    Not everyone can access an accdb, you may reach a broader audience by attaching in mdb format.

    Bob Fitzpatrick

    I have never failed. I have found a thousand ways that do not work!

    Microsoft Community Contributor Award (2011)



  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,849

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    7,069
    It is likely corruption of a system table. A compact/repair might fix it, but I would back this one up first even though it might be corrupted because if it got worse after a c/r you can always start a fresh db and see if these objects are visible in a 'get external data' operation; i.e. importing all of the objects from the corrupted into the new one.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

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

Similar Threads

  1. Replies: 9
    Last Post: 07-19-2017, 11:01 AM
  2. Replies: 2
    Last Post: 03-23-2017, 01:47 PM
  3. No Objects in Navigation Pane
    By dmccarville in forum Access
    Replies: 2
    Last Post: 08-27-2014, 01:59 PM
  4. Replies: 2
    Last Post: 02-27-2013, 03:01 PM
  5. Replies: 5
    Last Post: 12-18-2012, 02:37 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 - Senior Forums