One of our departments had a working ASP interface for their database, but now they're getting the following error:
Error number -2147217904
Error description [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
SQL query select [Book ID#], [Author/Editor], [Title], [Publisher/Year], [Location], [Category], [Key Words], [Status], [code] From [Library] where (1=1 and [Author/Editor] like 'th%')
I checked the database and all the fields are still there and have the same names. The database name has not changed. Where else should I look??? What could have happened?