Running MS Access with SQL Server

Madison

I am going to be creating numerous reports for a future client using MS Access (possibly 2007).

My client is running SQL Server (possibly 2005).

What are my options for running MS Access (front-end) with SQL Server (back-end)?

My client mentioned stored procedures and MS Visual Studio (version ?). I've only used MS Visual Studio with Reporting Services. Not MS Access.

So far, the only choices that I'm aware of are:

* ODBC

* OLE DB

* Pass through queries in MS Access

* Invoking stored procedures with pass through queries in MS Access

I suspect that I might need a specific connection string.

I need to mention that I haven't been to my future client's site yet.

Thanks in advance for any assistance.

Sincerely,

Mike