Frontpage form query problem

[usads2]

When I click Submit Query on my search page, the database returns all results as opposed to the search criteria entered. In fact, I can leave all fields blank and it will still return all results in the database. The page (still very much under construction) is located at http://www.driverreport.org/driversearch.asp

Any ideas on this one? 

[kpac]

Is it an IIS server you're using with Access database?

[usads2]

It is an Access database, however I am not sure what an IIS server is. I know it is on a Windows server (if that helps) 

[kpac]

Yes, IIS in the same as Windows.

I'm sorry I don't know much about Access databases, so all I can do is point you in the right direction.
http://www.stardeveloper.com/articles/display.html?article=2000051001&page=1
http://www.hotscripts.com/category/asp/scripts-components/search-engines/

[usads2]

Thanks again kpac. I am glad I cam across this forum. I have posted to many forums across the web and this one blows all the others out of the water as far as knowledge and promtness.

[kpac]

No problem and glad I could help.

[BC_Programmer]

I'm sorry I don't know much about Access databases

Actually- it uses pretty much the same SQL your familiar with from MySQL.

in this case, it simply looks like there is no actual query being created from the POST'ed data; that is, it is returning all records simply because it hasn't been told otherwise (think, performing a "query" that is just the table name- it returns the entire contents of the table).