MS Access is actually a user front end and not a database engine at all.
Many people don't understand this. A front end talks to a database
engine, known as a data source in the lingo. MS Access defaults to using one of Microsoft's databases, I believe it is called jet or something like that. MySQL is a better database engine. You can set up Microsoft Access to talk to mySQL. I have done it a couple of times. Here is the recipe how I did it
http://www.washington.edu/computing/web/publishing/mysql-access.html
It has also been
discussed on this list because I was part of the conversation. But if you want to use mySQL you have to either run a database server or some hosting services will give you a database on theirs free and you can connect to it remotely. Once you get your data source set up you can usually forget about it anyway.
The closest free thing to a generic front end to mysql is mysqladmin,
written in php. It doesnt have the polish of MS access though.
Dusan Spisak wrote:
Hello everybody!
I need to create some simple database. I've started to build it up in Microsoft Access. MS Access was really great for me, it was very easy and user friendly, intuitive. Without any manual I've managed to create a table, to create some views and queries and to prepare reports from them. But, I don't have MS Access at home. I don't want to use illegal software and I am not keen on buying it. That's why I've looked up MySQL. I thought MySQL could be something similar to Access, and for free, so I downloaded it. But now, I've installed it and I realized, that it's something different. There is need to run some server.... and i don't understand it.
Here is my question: Is it possible to use MySQL in the similar way to Access? Without any servers and administration and clients and controlcenter...? I don't need any network at all, I just would like to create and run some small database for home use. Is it possible in MySQL? And, it seems, there is no user interface in MySQL at all. Am I right?
Dusan
-----------------------------------------------------
Tato sprava neobsahuje virusy.
This message is virus-free.
Automatic GroupWise signature added by GWAVA. -----------------------------------------------------
<<<<gwavasig>>>>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
