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

    Just curious, which version of Access are you using?

    0 comments
  2. Anonymous
    2023-11-01T21:23:45+00:00

    The latest version of it

    0 comments
  3. Anonymous
    2023-11-01T21:24:45+00:00

    Access Version 2308

    0 comments
  4. ScottGem 68,775 Reputation points Volunteer Moderator
    2023-11-01T22:58:39+00:00

    What exactly are you trying to save here, the query or the results?

    I have NEVER used File, Save As, Save Object As to save a query, or frankly any object.

    Using that method (in Microsoft® Access® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit)it did add a new object to the query collection. But when I want to do that, I right click on the object in the Nav Pane, select Copy, then Paste.

    0 comments