troubleshooting Question

Need online database that multiple users can update; need recommendations on everything

Avatar of waughoo
waughooFlag for United States of America asked on
Microsoft AccessPHPMySQL Server
10 Comments1 Solution374 ViewsLast Modified:

I am running Windows XP Pro. I am a web designer (stress the designer, not the programmer!) for fun and occasionally for a little money. I would consider myself pretty good at HTML programming using Dreamweaver (which some disdain because it's a WYSWIG editor).  

I am working on a project for a non-profit of which I am a member.  We can't afford to pay a lot of money, we aren't on a time crunch, and I want to learn how to do this, so I'm using this as an opportunity to learn.

We need to create a web site/portal where several of us can go (password-protected, which I know how to do) and update records in a database.  What we're doing now is just emailing an Excel spreadsheet to each other, and obviously you can imagine the tedium and potential for mistakes that this can cause.  So we want to each take our stack of stuff that needs to be entered, go home, log in and update an online database as we have the time.  

The more I read, I feel that SQL is the way to go; it seems to be the most flexible. Currently I'm hosted on a server ( that will support pretty much anything--PHP, ASP, whatever.  However, if we need to change hosts, that is not a problem; I can do that.

I realize this is going to be a big learning curve.  I do own MS Access, but it seems like that is just not the best way to go; Access is more user-friendly, it seems, but MySQL seems more versatile.

I have tried going through a tutorial and installing MySQL on my machine, but I am so stuck it's not even funny.  I need to know where to start.

This may be way too wide-ranging for help here...I may be too far gone!  But if you could give me some advice and pointers, I'd be so grateful. I want to learn this, and I think it's a good opportunity.

Joe Wu
Developer | Solutions Architect | CTO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros