Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Access vs DotNetNukeAccess vs DotNetNuke
Previous
 
Next
New Post
8/6/2007 7:39 PM
 
Hi guys,

I am facing a strong opposition in my current job (financial company, 35 employees). Everything here is written in VBA into MS Excel or Access. Now I and a colleague are trying to convince the boss that this should be changed to a VB.NET desktop application or even a DotNetNuke portal that integrates all functionality. We are not sure about it, yet.

Well, however, there are reasons for using Access. Those mainly are:
- the integration with Excel (for generating reports)
- the fast front-end responses (however, the times to load the page are enormous)
- simple & fast creation of queries, forms and tables

So now I am thinking about how to argue against this. I am very looking forward to your responses.

Thanks.
 
New Post
8/7/2007 3:34 AM
 

Don't fix it if it ain't broke.


 
New Post
8/7/2007 4:01 PM
 
Well the applications are in fact too slow (and if a customer calls, 2 minutes for a form is really too slow.).
The boss is thinking about rewriting it anyway in order to make it SQL Server compatible.

So it is kinda broke.
 
New Post
8/7/2007 4:17 PM
 

Well, the most effective way IMHO is to build a sample app displaying the alternative.  Then, compare the cost of licensing Access installations, cost of maintaining installation support vs costs in developing and supporting with the alternative.  It may not get you what you want in such a small org, but I do think you need to examine what the expertise is at you org, and how much resource you can throw at a conversion from those apps to your proposed alternative.

You may find it's not a cost effective solution given the support/development staff level.  We put MS Office, including Access on the desktop, and let the users build their own apps, and support them, as well.  I wouldn't have enough time to troubleshoot their stuff or develop alternatives.  Although, much of what I use involves .Net, windows apps or web apps, I would not try to convert everyone in the org, becuase it would bring a lot of support calls to me, and I don't have that kind of time.

So, it's a question of Total Cost of Ownership, which includes support costs.  If you have to do the support, and queries anyway, you might win, but if the users do them, then, it's probably not going to work out without a lot of effort.

 
New Post
8/8/2007 3:56 AM
 

it depends on your use case:

  • Access with Jet Database is intended for single users
  • For multiple users, you can upgrade Access Applications quite easily to MS SQL Server
  • turning an Access Application into a web app means rewriting them
  • Access applications are easy to develop and usually it is easy to get access to the code and the data - but there is a security aspect of this as well
  • Desktop Applications need to be installed - if this is difficult (multiple locations) or there are a large number of users with manual installation required a web application is preferable

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Access vs DotNetNukeAccess vs DotNetNuke


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out