this is my third thread - no reply for previous two.. and what i found about my problem - run time parameterised query with ms- access is....
"
<B>Paramaterized Queries and the Access OLE DB Provider and ODBC Driver </B>
Due to limitations of the Microsoft® Access OLE DB provider and ODBC driver, parameterized queries are not fully supported in the Data Environment when connecting to an Access database, because the driver and provider do not return information about parameters (like data type and direction) in the query."

this is from..
http://msdn.microsoft.com/library/de...guidelines.htm

any comments.....?