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

DBG 11,711 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.

Was this answer helpful?

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.

    Was this answer helpful?

    0 comments