Using MS Access for Generating Report from ASP based website?

Is this possible? I will use the browser to nput data and use MS Access for
generating reports?

Re: Using MS Access for Generating Report from ASP based website?

On Thu, 2 Dec 2004 14:27:52 +0800, "A P" wrote:

>Is this possible? I will use the browser to nput data and use MS Access for
>generating reports?

Possible? Probably, but not practical. You would either need Access
on the server with a macro that runs the reports you could trigger, or
you'd need to pull the data from the server into a local Access
database to generate the reports. Look into Office Automation for
solutions, or figure out why you think you need Access to generate the
reports.

Jeff

Re: Using MS Access for Generating Report from ASP based website?

Or, you could do what I did. After recieving an astronomical quote from
Crystal Reports, we decided to use a Access ADP, which uses the SQL Server.
I just wrote the reports I wanted, threw the file up on the server (we are
using an intranet) and then when a user needs a report, they just open the
file, and then run any report they'd like.

If you need some more guidance, just shoot me an email, just make sure you
remove NO and SPM...

HTH,
Drew

"A P" wrote in message
news:eY0i3fD2EHA.3120@TK2MSFTNGP12.phx.gbl...
> Is this possible? I will use the browser to nput data and use MS Access
> for
> generating reports?
>
>

Re: Using MS Access for Generating Report from ASP based website?

Hi Drew,

Need more info on what you did. What is Access ADP? Can you share on how you
handle this?

Me

"Drew" wrote in message
news:OKHPY6J2EHA.3616@TK2MSFTNGP11.phx.gbl...
> Or, you could do what I did. After recieving an astronomical quote from
> Crystal Reports, we decided to use a Access ADP, which uses the SQL
Server.
> I just wrote the reports I wanted, threw the file up on the server (we are
> using an intranet) and then when a user needs a report, they just open the
> file, and then run any report they'd like.
>
> If you need some more guidance, just shoot me an email, just make sure you
> remove NO and SPM...
>
> HTH,
> Drew
>
> "A P" wrote in message
> news:eY0i3fD2EHA.3120@TK2MSFTNGP12.phx.gbl...
> > Is this possible? I will use the browser to nput data and use MS Access
> > for
> > generating reports?
> >
> >
>
>