RE: Access database conversion

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 <craig@tobyhouse.com>

---------------------------------------------------
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