Error information for Frontpage + Access (ASP)
I use Access designing a database for project management, including tables and queries; and furthermore use Frontpage to write into (table) and read from (query) this database, as active server pages.
Now we need to search all records whose complete date is between date 1 and date 2; in Access, I have designed a query, with criteria between [date1] and [date2], and it works well. But while I try to read it in Frontpage, it always shows error message, as following:
Database Results Error
Description: Parameter object is improperly defined. Inconsistent or incomplete information was provided.
Number: 3708 (0xE7C)
Source: ADODB.Recordset
Can someone teach me how to make it work properly?