Database - Web Based

I have a potential new customer that runs a non-profit organization that wants a web based database; it would be used to find and track donors, referrals, do some billing and follow up.  Right now, as I have been told, there are running multiple Access databases along with some Excel spreadsheets.  They want to do web based data entry accessible via the Intranet or Internet with Secure Login; ablility to make adjustments to the fields and they are open to any programming languages.  Although this is a minimum amount of information - is there anything anyone would recommend in order to do this?
Daren Anderson, MSISPresidentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
This will be a "Huge" undertaking.
Especially if you are new to database design and website design...

The Access 2010 "Web Database" may not be up to the task (New technology, Macro based, limited security, ...etc)

Most of the time when a "Web Based" solution is needed, it is usually advised to move the Backend to a SQL Server , .. and use a web development platform to build the interface:
(.net, ...etc)

But again, this will be a Huge undertaking, and the specifics will depend on many factors:
Skill level
Existing infrastructure

So there is no clear solution, unless we are intimately familiar with all your business rules, requirements, constraints, ...etc


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Daren Anderson, MSISPresidentAuthor Commented:
I do have many years experience using Access as well as many other higher end databases - SQL/Oracle; as well as a lot of experience in web design.  So I will agree this would be a huge undertaking for someone with less experience.  I probably should have not put this in the Access category.  Also, the details were very incomplete for anyone to make a educated guesstimate on it.  I am not sure on their budget but since it is a non-profit; I would think it is minimal.  Also, I am trying to find out there existing infrastructure - i.e. servers, SQL, etc.  I dont have that information as of yet.  I was thinking of looking at doing something in or something along those lines but with time constraints, I was wondering if anyone may recoomend something else with the very bad specs I have given.....
Rey Obrero (Capricorn1)Commented:

i would suggest using sql express ( it is free )

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Daren Anderson, MSISPresidentAuthor Commented:
Yes I have used SQL Server Express in the past....good thought..
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 If the current setup does what they want, then you may consider simply putting the Access databases on the web with something like this:

Another alternative is to run a terminal services server and have users remote in.

However if there truly a need for a web based end user app then you have two choices:

1. Use Access with Sharepoint - Expensive and as Jeff pointed out, may not be capable of doing everything you want.

2. Re-write the apps with something like ASP.Net.

Jeffrey CoachmanMIS LiasonCommented:

Thanks for the clarifications.

We always have to mention the skills required, because many user (with limited experience) will presume that this will be easy
(Just click the "Make web database" button)

Then all my initial posts should still be valid.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.