Development Direction

I'm hoping that someone can suggest a direction for me to get started to
update a current application that I built several years ago. I want to move
the following application to our organization's intranet and will need to get
training in the best method to achieve this. I am versed in Office VBA and
VB 6.0 but have not moved into the .NET arena yet.
The application in question uses SQL Server 2000 as a back end and Access
2000 for the front end. Users basically select options on an Access form
that is used in a pass-through query to SQL Server. The query logs into the
server runs the query and returns the data, not to Access, but to an Excel
spreadsheet. I did this at the request of the users and they have been very
happy with it for many years.
The problem lies when users get new machines or have their machines
re-imaged and our computer support group has to re-install yet another
application. It would be great if I could figure out a way to build a
web-enabled version of this application and it has been beyond the scope of
my knowledge for some time now. I would really appreciate any suggestions
you might have or if you feel I need to direct this question to a different
newsgroup. Please advise. Thank you... AlIf you are able to use Reporting Services this is pretty easy to do what you
want. You have the queries designed. They can use the portal that ships with
RS (Report Manager). Select the parameters and view the report and then
export to Excel. If you had your own web page you could go directly to Excel
but since you don't want to be creating your own web app my suggestion
totally uses the feature of RS. You design and deploy the report and there
you are BUT the problem is going to be the administration. It requires
having RS server somewhere that you can deploy against.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:FD312550-1020-4D2B-B913-AE40BB5A28BC@.microsoft.com...
> I'm hoping that someone can suggest a direction for me to get started to
> update a current application that I built several years ago. I want to
> move
> the following application to our organization's intranet and will need to
> get
> training in the best method to achieve this. I am versed in Office VBA
> and
> VB 6.0 but have not moved into the .NET arena yet.
> The application in question uses SQL Server 2000 as a back end and Access
> 2000 for the front end. Users basically select options on an Access form
> that is used in a pass-through query to SQL Server. The query logs into
> the
> server runs the query and returns the data, not to Access, but to an Excel
> spreadsheet. I did this at the request of the users and they have been
> very
> happy with it for many years.
> The problem lies when users get new machines or have their machines
> re-imaged and our computer support group has to re-install yet another
> application. It would be great if I could figure out a way to build a
> web-enabled version of this application and it has been beyond the scope
> of
> my knowledge for some time now. I would really appreciate any suggestions
> you might have or if you feel I need to direct this question to a
> different
> newsgroup. Please advise. Thank you... Al