Running MS Access with SQL Server

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:



* 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.



Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!