I have a bit of experience w/ Access, but I am looking for other
alternatives
to meet my database development needs. I want to create databases for
individual users-- which is better, Access or MySQL? I don't want it to
be
web based as of yet. Any insight/help will be greatly appreciated!
My Email: (e-mail address removed)
I think you're completely misunderstanding the two technologies involved
here.
I would no longer say should I use SQL server, or should I use visual basic?
how can you choose between visual basic, and SQL server? (and makes no sense
to ask this kind of question).
Microsoft access is a developer's toolkit in which you can build forms,
build reports, write code, and generally use the tools to build an
application.
When you choose to use MS access as a development tool, then you get to
choose the database engine. that database engine can be the built in one
called JET, or you can use MS access with SQL server, or even use it with
MySql.
however you can use the database engine in MS access called JET to create
reports, nor can you create forms with it, and nor can you write any code
with it.
MySql does not come with the forms designer, it does not come with a report
later, it does not come with a programming language and editor either. so it
has absolutely no tools to develop applications with, and as such is really
only a database server engine.
So asking if you'd use MS access or MySql is the same thing as asking who
should use SQL server, or visual basic?
So these two products are apple and oranges. It does not make ANY sense to
interchange the to technologies in the same sentence.
MS access is a development tool in which you build the user interface, and
you can choose what database engine technology who you want to use that
those set of tools. you can interface a web site to the jet database engine,
or you can use MS access to read and use the jet database engine.
MySql is a database engine, and has absolutely no relationship or any
simulatires to a development product like MS access.
And the reverse is also true, MS access is not a database engine. MS access
is a tool that lets you connect and read data from those database engines,
be it the embedded JET engine that ships with MS access, or SQL server, or
in your case MySql.
You can most certainly use MS access as a front and to work with MySql, but
MySQL has none of the development programming tools, forms builders, or even
report writers that ms-access has.
You might want to explain where you're going with this, but the tools are
completely different products and really have no relationship to each other,
and you can not develop applications with MySql. (you use it to store your
data, and build the application with MS access, vb.net, or even some web
developument system such as asp.net)
