[AccessD] Using the Report Writer Features of Access 2007against SQL Server Database Tables

Guys, this could turn into a really good article, if you can come up with 10 
of these tips -- you'll all get the usual credit and contact link.

Susan H.



>I do it all the time - it is a great combination.  It combines the security 
>of SQL Server with
> ease of use of access reporting.
>
> A couple of tips:
>
> 1. Whenever possible, create Views in SQL Server that combine tables as 
> required and link
> to them rather than doing your joins in Access.
>
> 2.  Use the built in SQL Server security features - Create a user/role 
> with Read-Only access
> to the data and set up your connections using those credentials.
>