Hi
We have 2 problems with VB 6.0/Access in its current state:

1. We have about 40 agencies using an individual copy of the application/code and they each FTP us some data out of their individual systems which we store in an Oracle database. We want to build one overall system which these agencies can log into over the Internet. So we would like an architecture that can support this.

2. VB 6.0 seems barely supported in Windows 7.0 and I believe Microsoft has stated they will not support it in operating systems beyond Win 7. So it seems we have to migrate.

What is the best way to deal with both of these problems, given the current VB 6.0/Access architecture?

Paul