Using MySQL tables instead of MS Access

What do I do next to get an input form for each contractor?

http://screencast.com/t/Ql0Oi2Sb
frugalmuleAsked:
Who is Participating?
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.

Ray PaseurCommented:
Suggest you get either of the beginning PHP+MySQL books that are listed in this article.  The process you're describing is called "table maintenance" and it's one of the PHP 101 exercises that we all have to learn.  In the books it will probably be a chapter or two, so as you can imagine it's not something we can teach in a back-and-forth email forum like EE.  That's why I wrote the article.  I believe that the Welling/Thompson might be the best choice.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
What I do is install rhe mySQL 5.1 ODBC Driver. Now you can create linked tables to the mySQL server tables. Now access sees the tables link any other linked table. You can create forms, reports, and queries against the linked mySQL tables as you normally would in Access.

I also use  http://www.heidisql.com/ for remote management.

NOTE: Your hosting provider myse allow remote access tot eh mySQL server. You will need to contact them to find out the connection settings to use when you set use the DSN for Access.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
frugalmule, the video is nice.  However, can you please try and phrase what you want in text so your question can be useful to others.

1) You have a MySQL database

2) You have some experience relational databases via MS Access

3)
A)You want an input form for a contractor to have "All data on one page"
B) each contractor will have a page
C) something has to be added each day?

For each of these, you should elaborate on the specifics.   I would even go so far as to build a static html page so we can see what you want to do.

Is this for a website? Desktop? Mobile?
What programming language do you use?
If you were going to do this in access, what would you do?

In the meantime, here are some very good articles you should read.

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_2391-PHP-login-logout-and-easy-access-control.html

Our job here is to help you help yourself.  Not write all of your code for you.  If you can let us know exactly where you are at as far as programming skills and languages you are familiar with it would be a big help.  We may need to break this out into multiple questions depending on what you are trying to do.

Please start by briefly detailing out what you want.  Make a few static web pages or forms or wire frame. (how to make test cases http://sscce.org/) Let us know your skills.
0
hnasrCommented:
"Using MySQL tables instead of MS Access"
Yes.
Just link the MySQL tables to your Access database.
Now your issue should be, linking a MySQL table to Access. Is this true?

I assume you know access and you can design other objects, and the linked tables will be just an access table object.

Hope this comment makes sense to your issue.
0

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
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
MySQL Server

From novice to tech pro — start learning today.