ASP and Access ADP reports

[pds65]

I've looked high and low for a solution to this with no luck. I'm trying to use this code -

http://www.4guysfromrolla.com/webtech/042600-1.2.shtml

- to generate Access reports in ASP. The problem is the Access file is not an MDB, it's an ADP with data and stored procs in SQL Server 2000. I have modified the code so that I can see the reports, but I get the following error:

The record source 'dbo.usp_DW_LotusOneWeek' specified on this form or report does not exist.

This is because the RecordSource of the report is set to a stored procedure. How do I get the report to pull data using the stored proc? Is this even possible? Thanks.

 

[psemianonymous]

Access ADP's are not access MDB's--I can't explain it, it just is so. You won't be able to pull the report using that code.


Getting reports from Access to the web (or any other non-Access platform) have been the discussion of many. I recommend you don't bother trying to web-enable your reports; instead rewrite them directly to some web-friendlier technology (Crystal Reports, etc.) or just keep your Access reports inside Access and give up on the web-enabling bit.

Sorry.