Forum Discussion
Access freezes when I copy a record
- I also did that and saw the problem remained
Yes, it occurs in any Access table or query with more than 1000 records
It started after the most recent update to Win 11
How is the table sorted? What Indexes are on it? I am assuming that it would have a Primary Key, but please confirm that, as well.?
Also, please confirm whether this is a local table in the same accdb, a linked table in a second accdb, or a linked table in a different database, such as SQL Server.
- Yes. I just tested a table with 920 records. Cut and paste worked normally. 1100 record table experiences a freeze not as long as 4900. 31000 record table freezes completely.
Primary key is ID and the only permanent index. Sorted on whatever column needs for the immediate function. Fails have happened on several different sorts.
These are all local tables in their own Access accdb's - Okay, then. I can confirm that this occurs as described in a local Access table with 300,000 records at any rate. Given that I'm going to assume there is a new problem that needs to be investigated with Microsoft. I'll see if anyone has reported this yet.
Can you also please provide answers to the questions I asked?ms 365 access not responding after doing cut and paste in local tableGeorge_Hepworth
This was appended to a discussion with over 100 responses. I don't think I want to read back over the whole thread to see if this is a response to a specific previous comment, or just tagged on to it.
Perhaps, though, if you read the thread and try some of the suggestions offered, you'll find something that resolves your problem.
Personally, I do not recommend copy/paste into local tables as a production method in any event because of the complications involved. It is probably more effective to import data from the source using automation.
George_Hepworth I am having this same issue over the last few weeks. When I need to update a record (in this case "cut" it to create a different, updated new entry) Access crashes when I "cut" the entry (an entire record). This is a member database with just under 10,000 entries. I have to do CTL-ALT-DEL and stop the program, which has freezed. When I restart it, I can paste the entry as a new entry in the database. Although I've used Access for 20 years, I'm a journalist and have no idea what some of the things you've been saying mean. I DID do "compact & repair" but that did nothing. This is a high end Win11 system. Obviously the most recent update to Access royally screwed something up. If I knew how to restore Access to how it was before the most recent "update" I would. This is very annoying.
- Since you addressed me directly, I'll add a note that a temporary work-around is, as has been suggested a few times in the thread with varying degrees of detail, to Run the application "As Administrator".
- just did
thanks for your help- It may be a a couple of days, but I sent an alert to MS Access team.
Also, thanks for the details.
