is ASp THE RIGHT CHOICE?

[aolb]

I have been asked for recommendations and estimates for upgrading a department’s Access 2 system.

One possibility is an ASP interface but is this the right choice?

The users would be entering data on the system.
The department’s physical location is in the same area.
The system would have about 30 different screens.

I’ve already cracked the reports problem by imbedding Crystal Reports into my ASP applications but I wonder if it may be better to just develop the system in a more recent version of Access or VB.

Any opinions would be welcome

 

[krisbrixon]

It would depend on the nature of the application.

If the program has a lot of data entry (bulk entry like payments for bills...) it would likely work better with VB.

If you think you will grow to a multi location site without physical network connection then ASP would likely work better.

ASP running on the network is much faster than over the internet, so you might want to test some data entry speeds against what you do now.

Personally I HATE Access for a development environment, but will use it for a database. Depending on number of users you might what to use MS SQL or MSDE for the database.

If you were considering ASP then use ASP.NET and write it so the business rules and data access is seperate from the forms so you could migrate to VB.NET if you wanted to.

If you are thinking about ASP.NET then check out Microsoft's Web Matrix program. This is a free editor for ASP.NET.

Kris

 

[aolb]

Thanks, it kind of confirms what I was thinking

steve