ASP script / MS access DB / Reports

[Neel]

Hello,

I need some help with the ASP/VB scripts ;

..OpenReport strRptName,acViewPreview,,strWhere

..OutputTo 3,strRptName,"Snapshot Format(*.snp)",
snpflpth,-1

I am trying to run a ms Access report from ASP/vb script
and produce a snapshot file as above and (it works
generally BUT )I need to pass [ID]= 10 as paramater to
the access 2002 report so that the report only picks up
on the record id = 10, I have tried the above, it pulls
out all the records.

Can anyone suggest what is wrong in the command above OR
Is there anything missing.
OR Can anyone point me to the right direction ???

Regards,
Neel.

 

[clintonG]

There's probably several developers in other newsgroups that have
learned how to achieve this specific task. I would start here...

news://microsoft.public.inetserver.asp.db

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/