Unanswered: MS Access DB does not take "Where" parameter?
I am trying to use VB script in ASP with MS Access DB on IIS 6.
I connected the DB, and can "select", "insert", and etc.
But looks like Access doesn not let me do "select * from tablename where fieldname=valuehere"
If I delete out the "where...", it works perfectly fine.
So is it the limitation of access database?
I know when I use Access DB with VB Script ASP, it will not allow "Recordset.MovePreviews", but is the "where..." syntax not allowed as well?
Any help will be greatful.