Has anyone ever had to connect to a Access database via OLE DB connection while developing/distributing RDL reports? If so, what obstacles have you faced and how did you get around them? I am doing a report like this with named parameters and I am having a very difficult time in retrieving data. Your input is greatly appreciated! Eric Brenner Quality Information Specialist Dart Container of Michigan, LLC

This tutorial will guide you on how to create RDL report in SSRS with Access ODBC Data Source. Integrating Microsoft Access DB, SQL Reporting Services and Visual Studio .NET In your case you cannot use name parameters, but instead you use un-named parameters. Ex: select * from table where att1=? or att2 between ? and ?

Irusul, I should have been more clear. My apologies. I've already connected to the Access DB using OLE DB but it's the paremeters I am having difficulty with. It would be best if I could use the named parameters but I read that these cannot be used and I must use unnamed parameters which cannot be updated. Is this true? If so, this is a REAL bummer.

OLE DB does not support named parameters, only unnamed parameters.

Is it possible to update a unnamed parameter via a named parameter?