Solved

developing a distributor profile database application for the intranet

Posted on 2008-10-12
3
323 Views
Last Modified: 2013-12-25
I'm going to build a database for a small companies intranet using either Access or Sql Server. I have a lot of experience with building Access applications and I sometimes use Sql Server as the back end (all the apps. normaly use forms, subforms and reports in Access and I have used Excel to display and a lot of vba).
I have only built one static web page using Front Page. I have downloaded and looked at MS Visual Web Developer '08 express edition, so, am thinking of using that, but, wanted to get some feedback.

The main purpose of the app will be mostly contact management, tracking demo equipment dealers have, summarizing phone conversations, stuff like that.

So, I could do this in Access using forms/subforms for input and tracking and maybe a report or 2, but, I really don't know how to get it to display on a web page (which is what the customer wants). There will only be 5 - 10 internal users and maybe up to 5 external users.

- Would VWD be a good way to go?
- I don't think it will be hard to publish the final product to their intranet, but, not sure how external employees would view (maybe remote into the server?)
- I have looked at Access DAP, but, couldn't figure out how to do subforms. Should I consider using DAP?
- Other thoughts and comments are greatly appreciated.

thanks
0
Comment
Question by:avoorheis
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
MarkusEilers earned 500 total points
Comment Utility
Hello avoorheis,

generally speaking, Access is probably not an option for the intranet application you want to develop.
Also without further knowledge of your situation: ASP.NET is surely a great choice for creating web applications and has - apart from the masterpages concept, webparts, perfect SQLServer integration and many more -  great support for authentication ( internal/external users , ActiveDirectory support, Membership Provides ) etc. . So yes: Go ahead with Visual Studio or VisualWebDeveloper (which is the ASP.NET focussed "Community Edition" of VisualStudio ).

Note: I would love to give you a more comprehensive advice for things that will be hitting you on the road.
- Integration with the used CMS / How to provide CMS functionality ( aka "The Intranet" :) )
- Authentication approach
- Community / OpenSource Software that may be applicable
- Books / WebCasts etc you should have standby when finalizing everything on Saturday evenings :)

To do so, I need more information on which products you are planning to use ( CMS, Webservers if not IIS, Windows Servers, Database Cluster or not, external access per portal or via VPN ? ).

Kind regards and a good start with ASP.NET !
Markus



0
 

Author Comment

by:avoorheis
Comment Utility
Thanks Marcus,
Please note that as far as web publishing, I'm a noob, so, please go easy on the acronyms.
Not sure what CMS is, but, we're planning on creating a MS SQL database and doing a simple as possible display and edit of records. I thought a web application would be the best since this will be used by just company employees, which some are external.

They use windows server, but, not sure if it 2000 or 2003 and I thought that IIS would work, but, am not sure how the external users would connect. That's possible, right?

I do have a couple of beginner books for visual web developer, so, I guess I'll start there?
0
 
LVL 1

Expert Comment

by:MarkusEilers
Comment Utility
Hello avoorheis,

sorry for the jargon !
If you are planning for a Intranet you will typically use a system to manage content ( news, user profiles, applications like the one you are planning ). Those systems are called CMS/eCMS. Sharepoint Server, dotNetNuke, Typo3, OpenCMS and others are well-known Content Management -/  Portal Management Systems.

Back to your question:
If Intranet is not what you are looking at: You could of course implement a multi-user solution with MS Access and Virtual Private Network. But Access is close to the end of its life-period. Another very good option could be a SmartClient ( implemented in .NET with WindowsForms /  WPF e.g. using the SmartClientFramework from the Microsoft Patterns&Practises Group ). If you need integration with a web frontend technology or the clients are heterogenous ( Mac, Win, Linux ... ) and you don't need local resources on the client pc ( sound, 3D graphics ... ) then a website will be the most common solution.

And within the range of developing websites: Go for ASP.NET and VSWD !

Kind regards,
Markus
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Read about why website design really matters in today's demanding market.
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
The viewer will learn how to dynamically set the form action using jQuery.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now