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

Hi Brad:

Why not check this artcile out.

http://www.databaseadvisors.com/newsletters/newsletter112003/0311UnboundRepo
rts.asp

The code is fully documented and there is even a running smaple you can
download.

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, April 05, 2010 5:27 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Using the Report Writer Features of Access 2007 against
SQL Server Database Tables

Background - Small company, small IT staff, small budget, no report
writer like Crystal Reports, etc.

 

We are thinking about using the report writer built into Access 2007 to
create reports from data that lives in SQL Server (purchased application
system).

 

We have done a little experimenting and things seems to work nicely in
our preliminary tests.  Do other firms do this (use Access just for
report writing against SQL-server data).  Are we missing a big "gotcha"?

 

 ~ ~ ~

 

Is it possible to force "Read Only" access in the Connection String?  We
want to ensure that no one ever updates any of the data in the SQL
Server tables.

 

Thanks,

Brad 

 

 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com