A family of Microsoft relational database management systems designed for ease of use.
I just heard from MSFT and they are able to fix this issue right away. They said to wait 1 more hour and then restart Access and the issue should be fixed.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I had a call from one of my users today to say his database was just closing down as he clicked a button.
I got his front and back end files and ran them on a PC with Office 2010, they worked fine, but his Office 365 has been updated today and he has the problem on all his PC's.
I tried the front/backend files on two PC's I have that are running Office 365 and they too have the same issue.
It seems like Microsoft has broken things.
Is anyone else having issues after today's update?
Regards, Dennis
UPDATE: This mentions that the recent Office 365 update fixes problems in Excel, Outlook and Word, what it does not mention is that it broke Access! https://www.neowin.net/news/microsoft-365-apps-build-1512820224-resolves-issues-with-excel-outlook-and-word/
UPDATE 2:
I managed to program around the main issue I was having, however I have just seen messages to say Microsoft have fixed it, I just tried the original database and it seems to be working fine. Thanks to everyone who posted their experiences here, it was very helpful.
A family of Microsoft relational database management systems designed for ease of use.
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.
I just heard from MSFT and they are able to fix this issue right away. They said to wait 1 more hour and then restart Access and the issue should be fixed.
PaulRoss_499 That's interesting.
I found that I had code in a forms open event that used
Me.Recordset.FindFirst "lngRecordID = " & lngRecordToJumpTo
I have replaced that with
Dim recClone As Recordset
Set rst = Me.RecordsetClone
recClone.FindFirst "lngRecordID = " & lngRecordToJumpTo
Me.Bookmark = recClone.Bookmark
recClone.Close
Set recClone = Nothing
It now works without crashing as that form is closed, however, when I close the main form that closes the database I now get "No Current Record"
Problem started today, version 2204. I can reproduce very easily:
Seems that any access to form's recordset in VBA causes problems.
The workaround to use RecordsetClone instead of Recordset does not apply in my case. I have always used the RecordsetClone method.
Looks like a work around has been found, have a look here... https://www.access-programmers.co.uk/forums/threads/no-current-record-error-now-affecting-all-versions-of-my-database.323141/page-2#post-1825870