Sudden occurences of 3027 runtime error

[GraeagleBill]

I'm unable to find the source of a sudden occurrence of runtime error 3027 on a ".AddNew" statement.




There have been no changes to the code where the error occurs and I'm able to manually add new records to the underlying table of the "QRegistry" query. There haven't been any overt changes to the back-end or front-end mdb's security settings, so I'm at a loss to explain the 3027's?

[Missinglinq]

...I'm able to manually add new records to the underlying table of the "QRegistry" query...

But can you add a new Record to QRegistry...the Query itself?

Linq ;0)>

[GraeagleBill]

Thanks,

No, directly to the table. So, when I opened the query itself it appeared to me to be corrupted so I deleted it and re-created the query from scratch. All seems to be working again. What boggles my mind, and why I hadn't looked directly at the query to begin with, is that other forms that relied on the same query as their RecordSource were working perfectly.

Thanks again,
Bill