locked
The schema for this table has changed. You must refresh the table before editing or adding new records RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Access 2019: After receiving the message "The Schema for this table has changed. You must refresh the table before editing or adding new records ", I am unable to save records into my dB (Intakedb.accdb). (1) I  have refreshed and refreshed all, (2) I have tried to open the form in Layout view, but if does not let me, it displays the same error. (3) It does not let me open in Design view either, same error. (4) I have used the link manager to link a table to SharePoint list, it works without an error until the end. However, as soon as I try to add a record again, wham, the same error pops up. (5) I have Gear > Site Content > and noticed 8 iteractions of my table (see attachments), I tried to open the one dated 04/05/19 but I could not see anything to update the schema. 04/05/19 is the one, the date I want. (6) I tried to use a copy  of my dB from 04/02/19, nothing, same error. (7) I have followed 6 different MS and other solutions to no avail. These are some of the articles I have followed: "schema has changed - access and SharePoint | Microsoft Office Forums" , " How To Fix Microsoft Access Error 3851 - Solvusof", I even read this "Synchronize a SharePoint 2010 list with Access 2010" to see if there was anything that can help,…. nothing interesting found.  Is there any way to address this? Should I make my changes on my desktop access or make the changes in access 2019 in the cloud?. I would highly appreciate your wisdom and feedback on this matter. Sincerely. TempDavid



    Monday, April 8, 2019 8:07 PM