Need advice on converting VB application into a Web application

I have a VB6 application that uses MS Access as the backend database.

I want to look into converting this application into a web application.

Any ideas/thoughts?

Are there web sites that would help with this?
Is this something I could do with Visual Interdev or some other tool?

Any ideas/suggetions would be greatly appreciated.

Thanks!

"Ted Young" <tedyoung@connecticare.com> wrote:
>
>I have a VB6 application that uses MS Access as the backend database.
>
>I want to look into converting this application into a web application.
>
>Any ideas/thoughts?
>
>Are there web sites that would help with this?
>Is this something I could do with Visual Interdev or some other tool?
>
>Any ideas/suggetions would be greatly appreciated.
>
>Thanks!

Funny - I'm standing in the exact same place. ?'s like remote calls over
a large geographic space, data security, data replication (clientside/server
db) and object caching......

Ted,
Hopefully you used objects to contain your business logic/data access.
If so, you shouldn't have too much work. If you are going to continue to
use MS technologies you might want to look at SOAP(look at this no matter
which vendor) and ASP. For example ...

Browser accesses ASP page using HTTP. ASP page creates business object
that accesses a data object that accesses the Access db to retrieve/save
data.

OR

Application accesses ASP page using XML over HTTP. ASP page creates business
object that accesses a data object that accesses the Access db to retrieve/save
data.

Or some other variation.

Mark

"Kevin" <kvan1@hotmail.com> wrote:
>
>"Ted Young" <tedyoung@connecticare.com> wrote:
>>
>>I have a VB6 application that uses MS Access as the backend database.
>>
>>I want to look into converting this application into a web application.
>>
>>Any ideas/thoughts?
>>
>>Are there web sites that would help with this?
>>Is this something I could do with Visual Interdev or some other tool?
>>
>>Any ideas/suggetions would be greatly appreciated.
>>
>>Thanks!
>
>Funny - I'm standing in the exact same place. ?'s like remote calls over
>a large geographic space, data security, data replication (clientside/server
>db) and object caching......

Hi Ted.

You will have several issues to contend with. First: Scalability. If this
database is going to get large, I would advise SQL Server. There conversion
functionality built right into SQL Server that converts a multitude of data
sources. Try using DTS.

Also, stored procedures make life much easier whether it's an order entry,
data retrieval, data aggregation, or any other kind of data manipulation.

If you are stuck using Access the single most important thing you can do
for speed if you have many tables and joins is to create a query that perorms
the joins and query the query from your webs.

Use includes and functions for everything you possibly can in your webs.
If speed isn't an issue now it soon will be, so design for it up front.
Keep you pages "thin". The only logic you should have on your pages is
page specific error handling and a little javascript if you need dynamic
math.

There are several places you can get started. ASPToday.com, DEVX.com and
several other places have killer code to get you started. Also, look at
MSDN online, and the MSDN library if you have it.

I hope this helps

"Ted Young" <tedyoung@connecticare.com> wrote:
>
>I have a VB6 application that uses MS Access as the backend database.
>
>I want to look into converting this application into a web application.
>
>Any ideas/thoughts?
>
>Are there web sites that would help with this?
>Is this something I could do with Visual Interdev or some other tool?
>
>Any ideas/suggetions would be greatly appreciated.
>
>Thanks!