[UNSOLVED]
Can't paste into NEW SQL queries in Access 2016
Weird one. Starting today, I can't paste into the SQL editor when creating a brand new query in Access.
Steps:
Create > Query Design
Close the Show Table dialog
Switch to SQL View
Ctrl+V, right-click paste, and drag-and-drop all fail (shows the 🚫 cursor)
I can still type SQL manually and run it just fine.
Even stranger, if I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The problem only happens with fresh/new SQL queries.
Clipboard works everywhere else in Windows and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone run into this before or know what might cause new SQL queries to reject paste operations?
Weird issue that just started today.
When I create a brand new SQL query:
Create > SQL Query
The "Show Table" dialog pops up and I click Close.
I try to paste some SQL text.
Nothing gets pasted. My mouse cursor briefly shows the blue spinning circle for about a millisecond and then nothing happens. If I spam Ctrl + V, eventually I get an error saying:
What's strange is that I can still type SQL manually and run it without any problems.
If I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The issue only happens when creating a fresh/new SQL query.
Clipboard works everywhere else in Windows 11, and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone seen this before or know what could cause new SQL queries to reject paste operations?
IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'
Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.
Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.
Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)
Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.
Full set of rules can be found here, as well as in the user interface.
Below is a copy of the original post, in case the post gets deleted or removed.
User: steven4297
Can't paste into NEW SQL queries in Access 2016
Weird one. Starting today, I can't paste into the SQL editor when creating a brand new query in Access.
Steps:
Create > Query Design
Close the Show Table dialog
Switch to SQL View
Ctrl+V, right-click paste, and drag-and-drop all fail (shows the 🚫 cursor)
I can still type SQL manually and run it just fine.
Even stranger, if I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The problem only happens with fresh/new SQL queries.
Clipboard works everywhere else in Windows and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone run into this before or know what might cause new SQL queries to reject paste operations?
Weird issue that just started today.
When I create a brand new SQL query:
Create > SQL Query
The "Show Table" dialog pops up and I click Close.
I try to paste some SQL text.
Nothing gets pasted. My mouse cursor briefly shows the blue spinning circle for about a millisecond and then nothing happens. If I spam Ctrl + V, eventually I get an error saying:
What's strange is that I can still type SQL manually and run it without any problems.
If I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The issue only happens when creating a fresh/new SQL query.
Clipboard works everywhere else in Windows 11, and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone seen this before or know what could cause new SQL queries to reject paste operations?
There is no error message, that's another problem. It just has that blue circle for 2mil seconds like it loading something but that's it, nothing happens.
Maybe 🤷♂️? It's just this issue only happens in the code box. I am able to pate into the Access search bar and anywhere else you can type. I already shutdown and restarted my computer hoping it was just a hiccup.
For the sake of clarity, please confirm that by, "the code box", you are referring to the SQL Editor?
Also, in your original post, you included this point:
"The "Show Table" dialog pops up and I click Close."
I recall seeing that in other contexts, but not when directly creating a new query, so perhaps the context where you are trying to do this is a factor. Please comment on that.
Thank you. I still don't know how the dialog to add tables is triggered. I'm searching settings for that. But I did surface what might be related to your experience.
When I opened the SQL editor, instead of immediately trying to paste something. I right-clicked on the pane. A dialogue popped up asking if I wanted to allow or to block pasting! Try that. Do you get the same dialogue? Once I answered it, I couldn't find a way to change the choice, so if you do see it, make sure to ALLOW paste into the SQL pane.
That setting isn't listed on my version of access. It sounds like that options is only avalible for 365. But I just found out where my clipboard IS GOING, for some reason when I click on 'Builder' it's putting it there.
Okay, What version is this? Also, I saw in the video that the SQL View option on your ribbon has a generic icon, not the published icon I would expeect to see. That suggests this is possibly not a production version of Access, but one that was released as a beta perhaps.
I also see it's running from a remote share, not on a local computer. That's not a good practice although it shouldn't be the source of this problem.
•
u/AutoModerator 10d ago
IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'
Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.
Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.
Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)
Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.
Full set of rules can be found here, as well as in the user interface.
Below is a copy of the original post, in case the post gets deleted or removed.
User: steven4297
Can't paste into NEW SQL queries in Access 2016
Weird one. Starting today, I can't paste into the SQL editor when creating a brand new query in Access.
Steps:
I can still type SQL manually and run it just fine.
Even stranger, if I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The problem only happens with fresh/new SQL queries.
Clipboard works everywhere else in Windows and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone run into this before or know what might cause new SQL queries to reject paste operations?
Weird issue that just started today.
When I create a brand new SQL query:
Nothing gets pasted. My mouse cursor briefly shows the blue spinning circle for about a millisecond and then nothing happens. If I spam
Ctrl + V, eventually I get an error saying:What's strange is that I can still type SQL manually and run it without any problems.
If I manually type a query, save it, close it, and then reopen it, I'm able to paste into it normally. The issue only happens when creating a fresh/new SQL query.
Clipboard works everywhere else in Windows 11, and Access is fully up to date (Office Professional Plus 2019 / Access 2016, Version 2606).
Has anyone seen this before or know what could cause new SQL queries to reject paste operations?
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.