ODBC Microsoft Access Driver] Too few parameters. Expected 1.

[vireshkolagimat]

Hi All,

I am using the attached query to access the data from SQL server and it just works fine. The query is built in SSMS.

But when i try to use the same query to extract the data from MS Access database, i am getting the above error.

Both my sql server and ms access database have same  table structure and same columns.

Attached is the query for your reference.

Thank you.

Regards,

Viresh