Forum Discussion
Access freezes when I copy a record
- I also did that and saw the problem remained
George_Hepworth Hi sorry, I didn't see these posts until now. I'm using a local Access database, Office 365, default database format, local tables in the database, nothing SQL linked. I'm copying and pasting in a query that is simply a listing of the table with sort on a date field. The table has one auto-number field (not the Access default index field). The table has approx 30,000 records, *but* in my attempts to narrow down the issue, I had created a fresh database and created a table, and had the same issue with much smaller fresh tables, e.g. 10 to 20 rows. For some new tables I didn't have the problem, others I did, and I thought that it might be because of a certain field type, e.g. date, but I haven't narrowed it down from there. The issue seems to have started after I had a Windows 11 update, but I can't be sure that it wasn't just coincidence. (However my inclination is that the Windows update started it.) The primary symptom is that if I pick a row and copy it Ctrl-C, then go to the new row line and selected it and paste, Ctrl-V, it freezes hard. Same with multiple rows. Another symptom is that there are queries I can copy and then paste into Access (I know about links from Excel to Access but that technique isn't effective with ever-growing queries), but the paste operation is extremely slow, e.g. 5 to 10 seconds to paste 1000 rows from an Access query to Excel.
I am having the same problem with a database I have been using for more than 20 years with 12,000 entries. Recent change from Microsoft 10 to my new computer with Microsoft 11. Was not a problem before the change. I saw that you let Microsoft know, any word on if they have fixed it? Thanks for your work and help.
Carla
- Brand new Windows 11 PC, out of the box, installed Office. Same problem, database is linked to SQL Server. Can copy the data in a single field/cell in a table just fine. If the user selects more than a single field/cell Access crashes, waited up to 5 minutes, nothing. Tried uninstalling update, unable to uninstall.
Been using this database for at least 20 years. Moved it to a Sharepoint Site, for all non-Win 11 users copying works just fine, for Win11 users, copying more than the data in a single field doesn't work at all.- This is quite likely to be the result of the Windows bug previously reported in this thread. Microsoft is aware of it.
However, you say "Moved it to a SharePoint Site...." That's a bad idea. Trying to run an Access accdb from SharePoint creates problems. Move the Back End accdb of the relational database application to a shared folder on your network and give each user a copy of the Front End accdb, which is installed on their own computers.
- Thanks, much appreciated. I could always produce a screen video showing precise steps, if that would be helpful, but I'll await word from the MSC Access team.
- Thanks to you both. Jon and I seem to be experiencing the same issues. Also the largest database of mine 31,000 records asked to be backed up to a new BAK file every time I open it. The MS Access team was supposed to contact me yesterday afternoon but did not which suggests they had no figured it out yet.
