MS Access Front Vs ASP 1

[anon47]

I need some help deciding our new system. I want to build our system so that it is completely online with a MSSQL backend. I want the front end to be entirely web based! The questions below are what I need answered and if you have any concerns that I haven’t thought of please input them. It will take me a while to build this database so I want to see what I am up against far as functionality.



1. First thing, is the front-end being build with ASP as functional as with access?
2. Is it as secure or can it be made as secure as ms access front-end?
3. What kind of reports has to be used to replace the MS Access Reports?
4. Is it beneficial and scalable for us?

Thanks for everyone’s input!

 

[anon47]

One more thing the data base will not be excessable threw the web, only threw the asp pages. And we host our website locally so we can have more controll over things like this.

 

[mrdenny]

1. An ASP front end can be as functional as you write it to be. So Yes

2. An ASP front end can be more secure than an Access front end as security with Microsoft Access isn't the strongest (depending on how you do it).

3. You can use any reporting method that you want. Microsoft Reporting Services comes to mind as does Crystal Reports to name just two.

4. A web based app is the most scalable method of presenting an application to your users. In the event that the web server is ever over loaded you simply add another web server and load ballance them.

Hosting internally isn't a problem at all.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[anon47]

Thank Denny for your response!

I will now set out on my quest and if I start now it should be a very needed in our company when I finish.

 

[harebrain]

I couldn't have said it better myself, mrdenny; have a star! (But this probably belongs in an ASP forum...)

 

[anon47]

Couldn't decide which one to put it in but sence I was talking about MS SQL as the back end point referrance I decided to go with this one. Thanks for all the in put guys.