Share via

Access Copy Paste 1 record takes forever

Anonymous
2022-11-19T04:00:09+00:00

Copy a record in a Table takes forever, around 5 minutes!!!

For several years prior Copy would take 1 nanosecond. Now after about 5 minutes I can finally Paste Append the record. Before that time I get the dreaded "Not responding" message but after several minutes that goes aways and the database works as expected until I try to copy again. Happens all the time now with COPY in this database. I have a few other databases where Copy is immediate so seems to be just this one database that is accdb created Dec 2019 3.7 MB just 1 table with 6808 records Office 2019 Access version 2210 build 15726.20202. Fields are all Short Text or number, plus 1 Date and 1 AutoNumber that is primary Key. Nothing else has a delay except for COPY. Database has a bunch of Select queries that run immediately.

Started happening after upgraded to Window 11 22H2. Maybe coincidence. Office Updates are automatic so everything up to date and unsure when last Office Update was.

Again this just started happening and I have been using Copy + Paste Append 1 record for years with no issue. If I wait long enough it works but who can wait that long really. I tried copying the database but same thing happens. One thing that does work is CUT (instead of COPY) the record then PASTE APPEND it twice so I get back the original plus can edit the duplicate but that is a bizarre workaround.

Cant think of anything else to try since Copy-Paste Append is pretty simple. I did not try an Append Query since Copy-Paste should work and is simpler for a novice like me.

Microsoft 365 and Office | Access | For business | 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

29 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-17T13:02:32+00:00

    Add me to the list of people experiencing the exact same issue. I can't believe this was reported as long ago as AT LEAST November of last year and it hasn't been addressed yet. Makes me dislike Microsoft even more.

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-12-27T22:07:12+00:00

    I have been having the same issue on Windows 11 22H2 and the latest version of access. Even copying 2-3 records (from a table showing on a subform) takes a few seconds to complete. Pasting them to the bottom of the same table hangs the entire database 50% of the time. Sometimes it recovers itself after 30-60 seconds, sometimes it hangs indefinitely.

    Microsoft - when can we expect a fix to this? It has paralyzed my work with multiple databases that have worked flawlessly for years. The key question is *when*, not whether you are working on it. Is there a timeline when the fix will be implemented? This has been going on for months...

    Thanks

    7 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-11-22T19:09:19+00:00

    I have the same issue. Only started happening after Win 11 upgrade. Even copying one field in a record takes over 5 minutes. Never happened before and using Ctl C does the same. Pasting from Excel works fine, but pasting into Excel from Access results in error.

    6 people found this answer helpful.
    0 comments
  4. George Hepworth 22,680 Reputation points Volunteer Moderator
    2022-11-19T15:10:41+00:00

    I'm convinced the current problem report is a new Windows 10 related bug. The Access team at MS has received the report and is investigating it now to determine if it is a bug.

    3 people found this answer helpful.
    0 comments