You can connect to the Access DB using open office and ODBC on any platform, but the Linux MS Access drivers all cost $$ while the windows ones are free. You will also need to rebuild all your forms and quires in OpenBase, but it is very easy to link to the table information. -----Original Message----- From: plug-discuss-bounces@lists.plug.phoenix.az.us [mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of Craig White Sent: Wednesday, September 05, 2007 4:44 PM To: Main PLUG discussion list Subject: Re: Access database conversion On Wed, 2007-09-05 at 16:08 -0700, Carlton Brooks wrote: > About 12 years ago I created an MS Access database for a historical > society to maintain their collection of material. > They would now like to make the information available on the 4 pc units > in their office instead of the one it is currently housed on. > I thought that if I set up their server as a dual boot box, converted > the access database to mysql, that they could run this as a local host > from the web browser. > > First off is this feasible, second I have found software on sourceforge > to convert the access database to mysql. But the biggest hang up is in > converting the forms and structure already created. Is there a program > that will convert the forms and output data so that a minimal amount of > work is required to set it up. ---- The Windows version of openoffice.org is capable of opening/converting the data into openoffice.org Base application - which then could use the data from another SQL store like mysql. -- Craig White --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss