Send Report to webservice

[Vanam]

Hi!
I'm doing a project which is based on old Access 2003 and VBA. I'm trying to upgrade the old reporting system which is based on windows service over to webservice. Im new to this kind of development so I get confused.
My new webservice is based on Visual studio 2008 vb.net. Is it possible to send a Access report to .net Webservice and export it to pdf on webservice? I would appreciate if someone could give some sample code on sending access based report to VS webservice
or give me another suggestion which will work fine.

Thanks

[rpeare]

if your 'new' reporting service is still using an access 2003 database there is no innate functionality to export a report to a .pdf. You'd have to use an intermediary product to do it. There are a few free ones out there that will give you drivers that you have to place in the same folder as the database that's doing the exporting but they will work just fine (if not as efficiently as 2007+ which has integrated the ability to export to pdf's directly).

I use(d) the product here:

http://www.lebans.com/reporttopdf.htm

[ItsMe]

I have used the code from this site for years now... I have tested it on A2003 and XP machine. I have not tested it on A2010 and W7 yet

http://www.lebans.com/reporttopdf.htm

[rpeare]

Same reference... I just modified the code the other day and it still works on an access 2007 machine.

[ItsMe]

...I just modified the code the other day and it still works on an access 2007 machine.

Good to know. I wasn't even paying attention to the fact that you had already linked the site. That code really has been helpful to me.

[Vanam]

Thanks all, I noticed ur suggestions today. I think i solved the problem on a hard way, I converted the VB code to .net on webservice and made New report on vb.net simuler to the oldone. I hope this will work fine..