> The question is what does Access do in order to > perform subqueries on MySQL via
>MyODBC driver > since it is obvious that they work?
access contains its own sql engine, so when you
link the mysql tables into it, you were then
running access queries.
> What can I do, but I do not want to use access > database as a layer between my
>application and
> mysql server? I use Visual Basic for accessing > mysql server.
you may need to do what you need in part sql and
part vb code instead of entirely sql.
i'm kindof surprised that you're getting such
good results from access. i've seen access
corrupt databases after they exceeded a gig.
also, in stress testing coremodel, access
immediately trashed its own database at the
beginning of every test, so i recommend caution
with access in production. to stress coremodel,
i had to move its database into a server.
> Greetings!
>
> I am aware that MySQL does not support subqueries. I have a 3 gb large
> database of bibliographic records. Database is designed by a model that is
> accepted by almost every library system, but there is one problem. When
> searching that database, nested queries are needed and there's a difference
> between mysql and every other database system. Now, when I linked these
> tables to Access database and used JET SQL everything was working very nice
> and nested queries worked too because Access Database supports them. Speed
> is impressive.
>
> The question is what does Access do in order to perform subqueries on MySQL
> via MyODBC driver since it is obvious that they work? What can I do, but I
> do not want to use access database as a layer between my application and
> mysql server? I use Visual Basic for accessing mysql server.
>
> Thank You very much
> Bruno
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
