Click here to Skip to main content
14,664,036 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi All,
There is an existing medium-sized application developed in MS-Access which is currently used by just 15 users. We are now in a fix whether to migrate to .Net (may it be Windows or Web) or continue with the existing application developed in MS-Access.
As this is not a huge application, do we have any positives the functionalities to .Net application? A comparision between the two(.Net Vs MS-Access) would be appreciated also the advantages of developing the application in.Net would help me too.

Thanks,
Posted

Rate this:
Please Sign up or sign in to vote.

Solution 2

This[^] whitepaper might help.
   
Comments
Ravikiran Santhanam 25-Mar-11 8:25am
   
thanks for that
Wendelius 25-Mar-11 8:47am
   
Wonder why you got 3, I think it's a good link, my 5.
Rate this:
Please Sign up or sign in to vote.

Solution 1

Those two aren't directly comparable since in Access you have both programming environment plus a 'database'. In .Net you have the programming environment so you have to choose a database to use, for example Sql Server.

About comparing those, few things come in mind:
- scalability, when the amount of data or logic increases you have much better tools if you migrate from Access
- control, there's much more control what's happening when using for example c#
- possibilities, you're not bound to the restrictions Access has for example in UI or in coding.

Of course those benefits have their downside, you'll have to possibly do a little more programming etc and possibly learn new techniques but that has never harmed anyone :)
   
v2
Comments
Ravikiran Santhanam 25-Mar-11 5:20am
   
Is it possible to compare the execution time of MS Access and .Net application + what about security related issues?
Wendelius 25-Mar-11 5:53am
   
Well not directly since there are so many factors affecting, but it's certain that you can achieve better performance with .Net and Sql Server than with Access. Security also is/can be much better with Sql Server.
Groulien 25-Mar-11 7:28am
   
And it's a lot more stable and less susceptible to file corruption.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100