Share via

Problem with query transferts

Anonymous
2025-03-13T17:07:50+00:00

Since the last Office update, when I try to transfer a query from one Access database to another, I get this error message.

It only happens with queries. Does anyone have the same problem and possibly a solution ?

I've never had any problems before and I haven't changed anything in the configuration...

Many thanks!

David

Microsoft 365 and Office | Access | For home | 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
Accepted answer
  1. George Hepworth 21,805 Reputation points Volunteer Moderator
    2025-03-13T22:37:15+00:00

    After some digging and conferring with colleagues, it appears that this is indeed related to the Monaco SQL Editor.

    The MSysSQLComments table is created

    1. When the Monaco SQL editor is enabled in an accdb
      AND
    2. When you first save a query in that accdb, with or without comments in that query's SQL.

    Later, when you export a query from that Monaco-enabled accdb or copy/paste it into an accdb with Monaco SQL editor disabled, the MSysSQLComments table in the target accdb is not available and isn't created because it's not Monaco enabled.

    That's the source of the error message.

    On the plus side, the query is successfully exported and runs as expected inasmuch as the comments table is not relevant in that accdb.

    I think the error message should not be displayed in this scenario, although it is technically accurate.

    If an error message needs to be displayed to indicate that comments on SQL made in the Monaco SQL editor will be lost when exporting to a non-Monaco-enabled accdb, that would be appropriate.

    In short, it's an inappropriately worded warning IMO.

    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 39,986 Reputation points MVP Volunteer Moderator
    2025-03-13T19:44:58+00:00

    I bet you this is related to the SQL Monaco editor. The OP may want to check File > Options that it is selected in both databases.

    0 comments
  2. Anonymous
    2025-03-14T13:47:24+00:00

    Thank you all for your help !

    I simply disabled the Monaco SQL type.

    I hated this presentation, so I solved both the error problem and the SQL query presentation :-)

    Have a nice day !

    0 comments