Share via

I am trying to save a copy of my query in Microsoft Access but it won't save. Please help.

Anonymous
2023-11-01T20:55:41+00:00

When I try to save a copy of my query in Microsoft Access, I press File, Save As, Save Object As, rename the file, and save it. I expect the query to save and show up in the Navigation pane but it will not. Only the original query shows up in the navigation pane and the copy of the query is nowhere to be found. Can somebody help with this?

Microsoft 365 and Office | Access | For education | Other

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. DBG 11,531 Reputation points Volunteer Moderator
    2023-11-01T21:32:13+00:00

    Thanks! I just tried to do the same thing using two different versions.

    It worked on this one: Microsoft Access 2016 (16.0.5417.1000) MSO (16.0.5413.1000)

    But failed on this one: Microsoft Access 2016 MSO (Version 2309 Build 16.0.16827.20166) Current Channel

    So, I might suspect it's a possible bug.

    2 people found this answer helpful.
    0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-02T00:58:47+00:00

    Have you tried to right click on the Query - Copy - in the Nav panel -right click Paste. It should pop-up a dialog to Rename the Query.

    0 comments