"Jeffrey Rolland" <wildstar200@[EMAIL PROTECTED]
> wrote in message
news:wildstar200-F89741.12185727032006@[EMAIL PROTECTED]
> Hello, all!
>
> I have MySQL loaded on Mac OS X, and I would like the best front end for
> it. I am willing to consider commercial front ends.
>
> I have used MS Access in the past, and, as much as I dislike Microsoft,
> I must admit, they really got it right with Access. I would like a front
> end that approximates their Query-by-Example screen as much as possible.
> I have Virtual PC and I am seriously considering purchasing MS Access
> and downloading an install of MySQL for Windows to just use MS Access
> and ODBC as a front end for MySQL.
If you merely want to use Access as a MySQL front end - you can do that!
There is no need to install MySQL on Windows unless you want to. Access
can
link tables to a Linux hosted MySQL server so it's really not necessary.
The Access query builder is a useful way to learn SQL just so long as you
are mindful of the differences between JET and MySQL. EG - Jets use of
brackets '[]' where MySQL wants to use back ticks, VBA functions vs. MySQL
functions, and date/time base differences.
Bear in mind, also, that you can define Pass Through Queries in Access
which
allows you to pass MySQL flavor functions directly to the server.
In the end, Access will look like a nice crutch you will eventually
abandon.
Unless, of course, you are trying integrate MySQL into the MS Office
system.
If that's the case, you will find Access to be essential equipment.
Thomas Bartkus
> Navicat seems OK, but is it possible to create other than inner joins
> with the Query Builder?
>
|
