Brad Marks
BradM at blackforestltd.com
Tue Apr 6 21:03:54 CDT 2010
Jim, Thanks. I appreciate the assistance. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Tuesday, April 06, 2010 7:14 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Using the Report Writer Features of Access 2007against SQL Server Database Tables Hi Brad: Why not check this artcile out. http://www.databaseadvisors.com/newsletters/newsletter112003/0311Unbound Repo 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.