"Dennis Willson" <giganews@taz-mania.com> wrote in message
news:KOSdnaH7JMCAHO_eRVn-jQ@baytsp.com...
> The actual structure for MySQL myisam is that a database is a directory, a table is a
file and the indexes for a table are a file.
> Once MySQL has been properly installed, you can create the appropreate directory and
then copy the files in and restart MySQL and
> the have the databases recoqnized (I have actually done this) and you can even do this
between Linux and Windows (I have actually
> done this). For InnoDB all tables go in a single file.
>
> No, Access does not support any of the stored procedures, triggers, transactions,
etc... the way the Access Jet works is to lock
> users out of the DATABASE when another user is accessing it. On a web application
where the webserver user is the one doing the
> access, then it doesn't appear to Access as multi-user, so the application has to take
some care that concurrent web users don't
> cause a database inconsistancy. On MySQL myisam does table level locking and InnoDB
does row level locking.

Thanks!