Share via

I keep getting error 3141 when saving a query

Anonymous
2025-04-29T12:50:16+00:00

I recently got access and whenever i try to save a query in any database the error 3141 keeps popping up. this has occured in multiple databases and dont know what to do. there is no spelling mistake in my query

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

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2025-04-29T15:54:55+00:00

Perhaps also:
File > Options > Current Database: Uncheck "Enable Monaco SQL Editor" if it exists.

Was this answer helpful?

1 person found this answer helpful.
0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-04-29T16:03:30+00:00

    Thank you so much this worked, now I can study for my IT SQL test 😁

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. George Hepworth 22,855 Reputation points Volunteer Moderator
    2025-04-29T14:12:17+00:00

    Do you have a table named "tblOwners" in this accdb?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-04-29T13:00:33+00:00

    SELECT *

    FROM tblOwners;

    Was this answer helpful?

    0 comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2025-04-29T12:53:20+00:00

    Please provide the exact error message when asking about an error.

    3141 indicates a syntax error in your SQL Statement. S we need to see the EXACT message and the SQL Statement. To show us the SQL Statement open the query in Design Mode and choose SQL View then copy and paste.

    Was this answer helpful?

    0 comments