topic ODBC Microsoft Access Driver] Too few parameters. Expected 1. in QlikView https://community.qlik.com/t5/QlikView/ODBC-Microsoft-Access-Driver-Too-few-parameters-Expected-1/m-p/1396111#M799131 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using the attached query to access the data from SQL server and it just works fine. The query is built in SSMS.</P><P></P><P>But when i try to use the same query to extract the data from MS Access database, i am getting the above error.</P><P></P><P>Both my sql server and ms access database have same&nbsp; table structure and same columns.</P><P></P><P>Attached is the query for your reference.</P><P></P><P>Thank you.</P><P>Regards,</P><P>Viresh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vireshkolagimat 2020-11-25T16:16:04Z ODBC Microsoft Access Driver] Too few parameters. Expected 1. https://community.qlik.com/t5/QlikView/ODBC-Microsoft-Access-Driver-Too-few-parameters-Expected-1/m-p/1396111#M799131 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using the attached query to access the data from SQL server and it just works fine. The query is built in SSMS.</P><P></P><P>But when i try to use the same query to extract the data from MS Access database, i am getting the above error.</P><P></P><P>Both my sql server and ms access database have same&nbsp; table structure and same columns.</P><P></P><P>Attached is the query for your reference.</P><P></P><P>Thank you.</P><P>Regards,</P><P>Viresh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/ODBC-Microsoft-Access-Driver-Too-few-parameters-Expected-1/m-p/1396111#M799131 vireshkolagimat 2020-11-25T16:16:04Z