Re: [MSAccessProfessionals] Record deleted error | Run-time Error 3167

Jim – Are you not making daily (or at least, weekly) backups of your data. If you have backups you can compare tables to find differences in records.

 

Regards,

Bill Mosca

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Jim Wagner
Sent: Tuesday, February 22, 2022 12:29 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Record deleted error | Run-time Error 3167

 

Michael

I have spent 2 days on this. I just compacted and repair and it I do not see the error anymore. But I do not know if any records are missing.

 

Thank You

 

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Cheeseburger <Michael.P.Devlin@Hofstra.edu>
Sent: Tuesday, February 22, 2022 7:56 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Record deleted error | Run-time Error 3167

 

If you try opening the tables that are involved, do any of them open with all the records as #DELETED?
We have encountered an issue with one of the updates that caused this with random users.  A note from our ITS team:
Remoted to user pc, uninstall and reinstall office 365 version 21111-build 701-20262 and it worked fine after. Stopped the update from updating.