Access database conversion

Bryan O'Neal BONeal at cornerstonehome.com
Wed Sep 5 19:44:28 MST 2007


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 at lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces at 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 at tobyhouse.com>

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss



More information about the PLUG-discuss mailing list