Forum Discussion
Access freezes when I copy a record
Windows 11 Office 365 Access
Suddenly, when I copied a record in the database Access froze as if it didn't have enough memory. I tried compact and repair, repairing Office, uninstalling and reinstalling Office 365, exporting the database into CSV and importing back as text into a new table in a clean database, after that didn't work, I reduced the number of entries by 80% and imported as text into a fresh table. It still froze as soon as I control-C for 45 to 50 seconds each time.
A completely different Access database is experiencing a shorter delay after each control-C
Has anyone encountered this error or know a reputable contractor who specializes in such file specific issues?
- I also did that and saw the problem remained
Any updates or work-arounds on this other than Run as Administrator? Our organization won't let users have Admin privileges 😞
Hi,
No news. The status and workarounds described in our documenting article are still the current ones. i.e. waiting on the release of the Windows fix and providing the users with datasheet forms for the copy action if you can't use the admin workaround.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon- Thanks for working on this. I have been able to use the admin fix, which I appreciate the group letting me know about.
Art_Menius Yes I've had exactly the same problem over the past several weeks. I copy a row, then when I try to paste it, it freezes. When I copy from an Access query and paste it into Excel, the copy-paste is very very slow, much slower than it used to be.
- Thanks. Have you been able to resolve. I have spent 3 hours with MS Business support with no progress
Art_Menius Nope, but if I get a chance I'll try to figure it out. I think it might be happened after a recent Windows 11 update.
- Just got a new CPU with WIN11 and I am having the same problem. Do not see an option to uninstall KB5019980
- You can uninstall it with the command prompt Microsoft manual uninstall tool, but I did that and it didn't fix the problem.
Thank you, I will try it. I hope you are able to get your issue resolved. I will let you know how my issue works out. Happy Thanksgiving!
- I am having the same issue. Very frustrating.
- It is clear from your responses that this is an Access wide issue that probably resulted from a WIN 11 update. MS support, including for business which is supposed to support Access, insists this a "table specific" issue - a flaw in one or more of my tables - rather than an Access issue. As such, they want $499 for me just to submit a ticket. Worst experience I have had with MS Support in 35 years. Anyone know how to communicate to the Access team that this is an Access issue?
- That's unconscionable. If I have time today I'll construct a simple step-by-step if creating a new table with the obvious freeze flaw, which will be indisputable by MSC support because it's a newly created table.
- Thanks. The front line people have seen the error happen but think it is specific to tables in my databases.
- Access freezes when I copy a record
Art_Menius Need to create a test environment / development server of our business database to protect data
Art_Menius
Several people at my company are unable to copy and paste from MS Access.
They are also unable to uninstall the update. It gives an error saying the update is required and cannot be uninstalled. Is there any update about this issue.- This thread seems to be the only source of information about the issue. I keep checking here and looking for Windows updates, hoping the Windows team has fixed the bug.
- The most common reasons for Access database crash include: Corruption in one of the reports inside the database can cause it to crash while launching. Erroneous code within a report can cause the process MSACCESS. EXE to terminate suddenly.
Regards,
Will- Just to add
So (for me) All features of Access runs fine, only untill I copy/paste an Entire Field/Line ( I can c&p single fields without any issues ie: no crash. Tried many separate data backups same issue..- I installed this week's WIN 11 update. No change. Larger Access tables freeze when you copy or cut whole lines
- FIXED! DEC. 17th 2022
(well for me any-case)
The Fix: Run as Admin. Note: (even if you are logged in the cpu as the admin
1): Close/save Access
2): Open Access as Admin.
1st. Must Right click on the .exe Access file
2nd. Select "Run as Administrator"
That's it! Let all know if this works for you & keeps working-
C_Smith
