Platform Advice..?? Please...

[TRYP]

All,

Currently we are running an MS Access application (front and back end) and we are contemplating going to a SQL Server backend. I pose this question to debate...

Do we stick with the same front end or switch to VB or C# or even ASP or ASP.net ?

Pros Cons ???

Thanks in advance,
TRYP

 

[vb5prgrmr]

Here is a short list

Going to SQL Server is a very good thing.

If you are going to use a fat client it would be faster to develop in VB 6.0 over C,C+,C++,VC++, VB.NET vs C# will depend upon what coding style you prefer (I know people who just love to code in VC++ and C# over VB and VB.NET).

Problems with a fat client in VB6.0 is deployment. This is not so much an issue in VB.NET.

With a thin client (ASP or ASP.NET) it is easier to deploy your application with every upgrade, and you can create (depending upon what language you prefer) middle tier business logic components that will be easy to upgrade.

Some may say that the problem with this (thin client and middle tier) is that it is harder to manage.

A lot of different things need to be taken into consideration, like number of users, transaction rate (Hi,Low,Med), what is the purpose, etc. etc.

I would think on this forum you will recieve many opinions, good luck in you reading.