C# or ASP?

[Steve1977]

As it stands I feel that our Access Database needs to take the next leap in order to bring it bang up to date (and to help me get a new job too hehe)

SO I want to create a front end for our DB that will make it viewable over the web and was wondering which form you guys would suggest?

I was looking into ASP but someone has mentioned I do it in C#...what do you guys think?

 

[fneily]

Do a search of this forum on ASP and DAP(Data Access Page). You'll get examples and debates on how to go. What version of Access do you have? What exactly do you want the users to do, just view or be able to input/edit data? How extensive is the data entry?
DAP's are easy to use, just remember they are web pages and reside outside of Access, you code them using JScript or VBScript not VBA. I created a web system with DAP's for my state's transportation department, which is used by hundred's of users.
You'll find most replys will tell you to use ASP. Most IT departments resposible for their web sites have heard of SQL and ASP, but never DAP's. So it may come down to a political decision bred from ignorance.

 

[JoeAtWork]

It's not really ASP vs. C#, it's ASP vs. ASP.NET. C# would be one of the possible languages if you go with ASP.NET (otherwise it would probably be VB.NET).

My preference would be ASP.NET, as ASP was a kind of cobbled-together collection of technologies.

If you are looking to the future I would stay away from DAPs, as they are gone as of Access2007. ASP.NET was designed to be a scaleable architecture, and allows you to build robust applications using Object oriented design.

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[Lilliabeth]

Let me offer some clarification here:

ASP.NET is a suite of tools available in Visual Studio: it is not a programming language, rather it is that subset of tools in Visual Studio that is specific to Web development.

ASP (called Classic ASP to make the distinction) is the predessor to ASP.NET and is eight years obsolote.

ASP.NET projects can be developed in any .NET programming language, though VB and C# are clearly the most popular choices.

I don't think it matters whether you use VB or C#. For what it's worth, in my area VB jobs are more plentiful but C# pays better.

If you are an Access programmer and are planning to move to .NET, be prepared for a big learning curve.



--Lilliabeth