ASP.Net vs Access 2010

Posted on 2011-03-16
Last Modified: 2016-02-11
I've used Access for many years and want to develop a simple web database (my 1st). It may have dozens of users, each with their own set of data.
1. Is it possible to implement it with Access 2010 without SharePoint?
2. It has been suggested to develop it in ASP.Net, which would entail learning all that from scratch. What are the pros and cons of the 2 methods?
3. My instinct would be to have a separate database for each user instead of 1 huge database. What do you think?
Question by:Tom Lobb
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 11

Assisted Solution

NurAzije earned 50 total points
ID: 35146212
You may look for some easier implementations, ASP.NET is not that easy, you need a server side scripting language which easily connects to access files. I work with WhizBase
You can ask for any support on the site on live chat, I work with them on several projects. You also can read my articles about WhizBase on:

Author Comment

by:Tom Lobb
ID: 35148337
This is a partial answer which I may explore, and may award partial points in the end, depending on other solutions that I receive..

Assisted Solution

chrisrbloom earned 50 total points
ID: 35148341
Sure it's possible.  Look at the tutorial videos for getting started.  Yes, you will have to learn some .NET language, but with the WYSIWYG editors like MS VWD Express, it's pretty easy.

I typically build an access/SQL server db with access as the front end, but build the .NET website to access remotely.

BTW, I would create a single database with user access - each user writes to the DB using their own userid - then queries for the informaiton coming back out uses the userid as a parameter.
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.


Author Comment

by:Tom Lobb
ID: 35148599
This is a more complete answer. I will research the areas suggested and award points depending on other answers that I receive.
LVL 74

Accepted Solution

Jeffrey Coachman earned 150 total points
ID: 35149057

This has been discussed countless times... al

<1. Is it possible to implement it with Access 2010 without SharePoint?>
Sure, but this is a HUGE topic...

<2. It has been suggested to develop it in ASP.Net, which would entail learning all that from scratch. What are the pros and cons of the 2 methods?>
The "Pros" would be many, (Too many to list here in detail) the only real Con would be that you would have to take the time to learn .NET.
Remember .net is Big, it is a Real, Here Now, Robust development platform.
You can use .net across many Platforms, can only really use Access vba with MS Office.
It took time to learn how to walk... (wanna go back to crawling?)
It took time to learn to drive a car... (Wanna go back to walking or asking other people to drive you places?)
It took time to learn how to use a computer (wanna go back to life before computers?)
Everything new takes time to learn, so I would not consider the time it takes to learn .Net a "Con".
(Suppose it saves/makes your company thousands of dollars.

<3. My instinct would be to have a separate database for each user instead of 1 huge database. What do you think?>
I have never heard of this design approach in any database system....

Most Access Developer may recommend dumping Access altogether and going with a SQL Server/.Net approach..
Ms Access never was, and probably never will (at least not in the near future) a "Web Friendly" application.
(Even with the new web Database functionality in Access 2010)



Author Closing Comment

by:Tom Lobb
ID: 35165862
I tried to check previous questions but didn't find these. I appreciate all the suggestions.

Author Comment

by:Tom Lobb
ID: 41409728
My project's been on hold for quite a while, but in a few months, I'll have time to work on it seriously. A development environment that's been suggested to me by someone whose opinion I respect very much is, the combination of PHP, MySQL and Javascript. Any comments about this alternative?


Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

724 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