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.

Michael Vilain wrote:
> In article <J_6dnaCvZMdmxu_eRVn-tA@comcast.com>,
> "Victor" <VicMoore028@yahoo.com> wrote:
>
>
>>"Dennis Willson" <giganews@taz-mania.com> wrote in message
>>news:mZCdnbvyGN0z0OzenZ2dnUVZ_sGdnZ2d@baytsp.com ...
>>
>>>
>>>Gary L. Burnore wrote:
>>>
>>>>On Tue, 8 Nov 2005 17:02:22 -0500, "Victor" <VicMoore028@yahoo.com>
>>>>wrote:
>>>>
>>>>
>>>>
>>>>>Nice thing about MS Access is it can be installed in my web FTP and I can
>>>>>make fast
>>>>>changes to the database by double-clicking in FTP view.
>>>>
>>>>
>>>>You'll have to explain what you mean by "in by web FTP". FTP is a
>>>>protocal. Not a location.
>>>>
>>>>
>>>
>>>I'll bet his using the ftp server capabilities in IE and in IIS to upload
>>>files and he
>>
>>doesn't have direct access to the web server.
>>
>>>With Access if the odbc driver is setup, then just drop the database file
>>>in place and
>>
>>it will work. No installation of executables.
>>
>>I have access to a shared server using my FTP Client (FTP Surfer). I can just
>>drag-and-drop mydb.mdb into a subdir on my shared web, and - voila! - can
>>access it from
>>my pages after setting up the driver.
>>
>>The nice thing about it is, for FAST changes and mods, I can just
>>double-click mydb.mdb
>>and it opens in Access. I can quickly add columns & change data if I wanted.
>>
>>Now, compared to MS SQL, which is on a seperate server. The only way to view
>>& modify
>>the database is by SQL commands - I can't directly view the database.
>>
>>
>>Can I use mySQL the same was as Access is described above?
>
>
> Ah. Much clearer. Since MySQL isn't a single data file, but a series
> of files and a server process that handles the SQL queries, my guess
> would be no. Leastways, it's a bunch of files on my MacOS X box but
> your shared server may implement the database differently.
>
> If you've used or managed an Oracle database, the concept of the
> tablespace where the data is stored and instance where the code and
> structures that define the database manager are used to describe a DBMS
> environment. A single-file database as you've described isn't the same
> thing at all, even if there are multiple tables within that file.
>
> With MySQL 5.0, more true DBMS features are being implemented,
> transactions and stored procedures--to name a few. Does MS Access JET
> implement these?
>