Run-time error 2508, etc.....

[kd11]

We have an app written in Access (2010), which suddenly stop working. When a user click on any button on the application the error: Rim-time error '2508' specified proc XXXXX or form does not exist. But the stored procedure does exists in the database (on SQL) and if I run the proc in Management Studio it runs without any issues.

I didn't see any MS updates apply lately on the server and really there are no errors in the Event Viewer, it seems that there is a dis-connect between the front-end (form) and the database. What could be the issue with this app?

 

[JHB]

Did you try a "Compact & Repair"?
Show the code behind the button which cause the error!

 

[kd11]

Yes I try compact & Repair and that did help.

When I click on debug when the error message pops-up, it brings up this code.
If ((Me.chkPatentSearch.value = True) And _
(IsNull(txtClient.value) = False Or _
IsNull(txtAssignee.value) = False Or _
IsNull(txtInventor.value) = False Or _
IsNull(txtTitle.value) = False Or _
IsNull(txtAbstract.value) = False)) Then
'Run patent report.
DoCmd.OpenReport "Patent Search Results", acViewPreview

 

[JHB]

Yes I try compact & Repair and that did help.

Okay - then the problem went away?