Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

This[^] whitepaper might help.
 
Share this answer
 
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.
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 :)
 
Share this answer
 
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, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900