Error 2105 all of a sudden

[TaliaKlein]

I have a form that has worked literally for years!! All of a sudden this morning it started given us error 2105 and will not load a new record.
Nothing that I know of has changed. Below is the highlighted code that appears after I click debug. I tried adding the record selectors and navigators to the form to see if I could get to a new record that way and it was disabled. Any help is appreciated.

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

[ItsMe]

How are you opening the form? Maybe you can use code to open the form in acAddNew mode? Have you tried commenting out the DoCmd code to see if other code fails, too?

[TaliaKlein]

It seems that I have some crazy bugs that have crept into my database because this all began when I did a compact and repair. I was able to resolve the problem by reverting to my backup back end from before the compact and repair.

[orange]

So you have gone to the backup. Now is everything working as expected?

[ItsMe]

OK, yeah. I see how this is related to the other thread. I posted there.

[TaliaKlein]

Everything is working but I still have the strange double PK in the client table and it is a bit worrisome that I can't do a compact and repair. I think maybe my database is suffering from old age. Thank you Orange and ItMe for your suggestions.

[orange]

Please explain strange double PK in the client table.

[TaliaKlein]

Hi Orange,
It seems that this is related to the problem that you have been helping me with in my other post with my client table and the compact and repair that made things worse. I don't want you to have to repeat your efforts, so let's bail on this one. I apologize for the parallel postings, but I didn't realize they were related until my brain surfaced from it's sleep deprived fog to realize that the only thing that had changed with the database was the compact and repair that I did to figure out the other problem.