Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
QueenKirsty
Starting Member
18 Posts |
 Posted - 2009-06-23 : 08:17:10
|
| My company currently runs SQL Server 2000 back end and uses MS Access for the user interface. Due to new company development we are looking to replace the MS Access front end with something else.The interface needs a serious re-vamp and so whatever we use to develop the new front end we will be effectively starting from scratch. The system is a Network Operations DB and has highly complex data that needs to be presented in a number of different ways dependent on the user type and the situation. It is currently data-driven and we want to move to a more process-driven interface.I have only ever used Access as the front end before and was wondering what other development environments are good for working with an SQL Server back end? Any suggestions or stories of personal experience would be gratefully appreciated. I am looking to develop a sort of pros and cons list for different environments.I have some experience of programming but am anticipating that I will have to lean whatever language we decide to use so that is not a restriction. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-06-23 : 08:49:51
|
| do you need a web app or win forms (desktop) app to access data?in any case you should learn c# and .net.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
QueenKirsty
Starting Member
18 Posts |
Posted - 2009-06-23 : 08:58:44
|
| We have a multi-user environment on an internal (and isolated) network. In this instance, does it matter if it is web or desktop based? What is the difference if you are not using remote web access (i.e. over the internet)? Is one easier than the other?What is the advantage of c#.net over things like asp.net or vb.net?Thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-06-23 : 09:26:08
|
| > We have a multi-user environment on an internal (and isolated) network. In this instance, does it matter if it is web or desktop based? What is the difference if you are not using remote web access (i.e. > over the internet)? Is one easier than the other?desktop app has to be installed on every machine while a web app can be used by everyone. it can also be am internal web app not accessible from the web.> What is the advantage of c#.net over things like asp.net or vb.net?.net is a programming platform. C# and VB.Net are programming languages you use to develop in that platform. ASP.NET is a web platform built on top of the .Net and you can use c# or VB.Net to program it.which you use is your own personal choice. if you've programmed in access then vb.net will be more familiar.i personally prefer c# since i can't stand vb syntax.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
|
|
|
QueenKirsty
Starting Member
18 Posts |
Posted - 2009-06-23 : 09:32:16
|
| Thanks. That's fab! I will go investigate further! :) |
|
|
|
stevechristin
Starting Member
2 Posts |
Posted - 2009-09-10 : 01:41:17
|
| how many users do you expect to use the software?will you consider writing non-formal specs/screens and giving it to another company/developers? I think it can turn our to be cheaper and faster. another option I'd consider to layout some basic list of functions you'd like to get and then select a technology. Potentially there can be an existing solution for reuse.www.branegy.com |
|
|
|
|
|
|
Interface Development Ideas?