Share via

Cannot add Tables to Existing Queries in Access, grey sidebar opens right with no tables listed.

Anonymous
2020-05-13T15:47:59+00:00

We have the current version of Office 365 Business Standard with Windows 10 Pro, our database expert is stumped so I thought I would try the community. Recently when trying to add a table by starting a query design or using the add tables button or right clicking the top table area and choosing show tables the normal white box to add tables does not show up, instead there is a grey side bar that pops out on the right hand side that says add tables, and yet my tables are not shown there. I can add tables through the query wizard, but not after I create. All other data and existing queries access the data and work properly. My tables, forms, queries and such are visible on the left object pane. This problem only exist on my computer and all access databases on my computer (even the archives), all other office computers function properly. We have tried logging off and back in as a different user, also uninstalling and reinstalling office 365. 

[PII is masked by the moderator]

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Tom van Stiphout 40,091 Reputation points MVP Volunteer Moderator
    2020-05-14T14:48:39+00:00

    Others will see it too *if* they are on the same version of Office *and* on the same Channel. For example an installation of A2016 or A2019 will never see it. An installation of A365 Semi-Annual channel will see it in several months, and A365 Monthly channel has it now, and A365 Insider Edition had it a few months ago.

    The separation between a Tables tab and a Linked Tables tab was a MSFT design decision.

    There is an All tab, with all tables and queries together.

    2 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Tom van Stiphout 40,091 Reputation points MVP Volunteer Moderator
    2020-05-14T23:42:56+00:00

    Done.

    Coming soon, I'm sure  :-)

    1 person found this answer helpful.
    0 comments

10 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-14T14:10:59+00:00

    Unfortunately I couldn't get access to open in safe mode, probably because it's not connected o the internet then.

    0 comments
  2. Anonymous
    2020-05-14T14:13:12+00:00

    So by your last post, this pane is a new feature and when the other computers in the office update they should see the same right-side pane instead of the white form box to add tables and queries? If that is so why are the tables showing up under the links instead of tables I'm not understanding that? Thank you for your help thus far.

    0 comments
  3. Anonymous
    2020-05-14T15:03:00+00:00

    Well that clears up a lot for me, I'm glad to know it's not in error. We thought something was messed up on my system. I'll pass the word along to the designers too. Thanks.

    0 comments