Access V.S. MySQL

MikeyBoi

New member
Local time
Today, 02:32
Joined
Apr 6, 2006
Messages
5
Hey, Just wanted to throw the question out there, I already asked another member on their opinion on this but havent heard anything back yet, so im going to also throw the quesation out here as well and see what i get. Im new to databases and started out trying to learn Access with the intention that what i learned in Access i could use to learn MySQL, I figured access was a easier starting point to get my feet wet. I eventaully want to apply my databases to the web and im not sure but just wanted to find out. Does access have capabilities to manage a site where customers create an account on the site and log in and everything?? I was thinking access cant really do it and if it could it might be hard, so thats why i was looking into MySQL. I guess what im really asking is whats the difference between Access and MySQL, and what advantages and disadvantages do they have?? Everybodys opinion is welcome, it all helps me out. Thanks! ~[MikE]~
 
I have very little experience with mySQL, however I understand that it is probably the cheapest route to web database design, and has some excellent support from The mySQL community. I believe you need to use something like php for your web design and link this back to your mySQL server.

If you are just venturing on a hobby project, then I think mySQL and php would be a sensible route. However if you are trying to learn a skill which you want to use all your life, which you want to use to make money, then I would suggest you seriously look at The VS.net (visual studio)
 
I looked at the ratings of which MySQL was involved in with the Big Three, and MySQL was in there next to the top.

Unfortunately, if you plan to embed the database into your application and distribute it, then there is a charge, which honestly doesn’t make any sense because Microsoft, Oracle and IBM all have ‘free’ versions available for Independent Software Vendors. The price I was quoted was above $200 per single instance of an application distributed... actually there were two flavors and that was the cheaper one.
 
Database driven websites

If your looking to create a database driven web application then a good starting point would be ASP.net 2.0. I have just started learning this myself and it provides connectivety with Access databases.

You can also download Visual Web Developer Express 2005 from www.asp.net which I believe is free for a year and gives you a nice GUI to drag an drop dynamic controls.
 
Ok... So ive been looking around and saw a few things that sparked my intrest..... i discovered thisthing called DOT NET NUKE... is that the same as ASP.NET???? Its opensource.... and with my low budget rightnow..... opesurce has always been there for me..... check it out and let me know what you think.... ~[MikE]~
 
If I remember correctly, PHP can connect to just about any database, including Access. But then all you would be getting is basically a static data storage from access and PHP just linking to drag the data out. No forms, no reports, none of the fancy stuff access does.
 

Users who are viewing this thread

Back
Top Bottom