hafeez said:
I have a project that requires a database and I don't
know weather to use Access or MySQL. Is there a website
I can goto that compares them so I can decide which is
better for my project?
If not, then is there some resource I could use to tell
me what kind of projects Access was designed/best suited
for?
Any help would be greatly appreciated
TIA
Hum, I guess as long as you understand the difference between Ms-access, and
Oracle, or sql-server, or Mysql, then we are fine.
Remember, Oracle, sql-server, and MySql are just data engines. that means
you still have to choose a set of tools with which to create the application
with. So, with sql-server, or MySql, you can store data, but you cant create
forms or reports or develop the application part.
So, you have programming environments like C++, VB, and ms-access. These are
tools that let you develop an application (write code, build forms etc). So,
you use a tool like VB or ms-access to building applications that CONNECT to
your database.
Often, when people refer to ms-access, they mean the JET database engine.
So, assuming that you already chosen your development tools to build the
User interface (UI), then the next step is to choose what data engine. With
ms-access, two data engines ship on the cd. One is a file share engine
called JET, and the other is a free edition of sql server (both are on the
office cd).
And, if you wish, you can use ms-access with most commercial database
engines (Oracle, MySql etc).
So, in terms of number of uses, and the amounts of data, you can choose
ms-access to build the UI, and then choose the appropriate data engine for
the number of users, security and other reasons.
So, perhaps your first question might be why use Ms-access over c++, or over
VB, or over vb.net?And, then your next question would be what data engine to
choose?
Which UI tools to develop the application with will depend on what you need
to accomplish, and issues like distribution of the software. So, keep in
mind the choosing of the data engine is somewhat of a separate issue of what
tools you use to make the application with. Ms-access is a "RAD" tool. That
means it is a rapid application development tool, and it is very good at
building forms that allow you to edit data. However, ms-access is a poor
choice if you are going to write a space invaders game.
Feel free to expand on your question......
