Binding reports to Stored procedures, Access 2002, ADO, and SQL Server 2000

Terri

Guest

Posts: n/a

15th Feb 2006

Is it possible to bind a report to a stored procedure? I'd like to use ADO
to pass parameters to a SQL Server stored procedure to create a temporary
table and then bind a report to this temporary table. I'm familiar with
calling stored procedures with parameters using ADO from Access. I'm just
not sure how I can bind a report to this temporary table. If this is
possible examples and code would be greatly appreciated.

« How do I concantenate two columns in an Access table into one? | how do i login as a particular user into a secured database »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access Reports from SQL Server Stored Procedures	Drew	Microsoft Access Reports	0	16th Dec 2004 02:13 PM
Access 2000 stored procedures in Access 2002	=?Utf-8?B?RW1UZWVLYXk=?=	Microsoft Access	2	24th Nov 2004 07:36 PM
Access Reports calling SQL Server Stored Procedures	=?Utf-8?B?S3VtYXI=?=	Microsoft Access Reports	2	29th Jun 2004 04:00 AM
MS Access 2000 and SQL Server Stored Procedures	Tony	Microsoft Access	0	11th Jun 2004 12:27 AM
Execute SQL Server stored procedures from Access 2000	Thomas	Microsoft Access ADP SQL Server	1	12th Dec 2003 01:53 PM