Regarding using Access for an online public database, my understanding is that this can be done, but that Access falls over with more than a small number of concurrent users.

I did use Access for a searchable version of our database put up in a gallery for an exhibition in 2000 on a standalone PC, which had a web-form as a front end and ran in a browser (the web page was created in Access 2000, a so-called "Data Access Page"). This allowed people to create a filter to bring out the records they wanted, but to be frank it was a bit clunky and I didn't have the time to get it working in a user-friendly manner (though I'm sure it could be done).

> .. (the right way
> would be PHP and MySQL .. but leave that for another day) .. 

I'd concur with that, but you can also use PHP to connect to an Access database (using odbc_connect) and run queries using PHP's ODBC functions. It is however relatively trivial to export Access to MySQL.

> Roy Hemmat

Best wishes

Pete Gray
-- 
Peter M Gray
Museums Officer

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________

=========================================================
Important Subscriber Information:

The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).

If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).